CHAR_LENGTH() — Returns the number of characters in a string.
CHAR_LENGTH( string-expression )
The CHAR_LENGTH() function returns the number of text characters in a string.
Note that the number of characters and the amount of physical space required to store those characters can differ. To measure the length of the string, in bytes, use the OCTET_LENGTH() function.