Returns the length in characters of the string expression if the string expression is of a Character data type; otherwise, returns the length in bytes of the string expression.

 

Example:

SELECT CHAR_LENGTH('ABCDEFG') returns 7 (number of characters in string expression)