Syntax
CHAR_LENGTH(str)
Purpose
Returns the number of characters in the string str.
A multibyte character is counted as a single character. For example, if the input is five 2-byte characters, LENGTH() returns 10, and CHAR_LENGTH() returns 5.
Examples
obclient> SELECT CHAR_LENGTH('China'), LENGTH('China'),CHAR_LENGTH('hello');
+-----------------------+------------------+----------------------+
| CHAR_LENGTH('China') | LENGTH('China') | CHAR_LENGTH('hello') |
+-----------------------+------------------+----------------------+
| 2 | 6 | 5 |
+-----------------------+------------------+----------------------+
1 row in set