Syntax
CHARACTER_LENGTH(str)
Purpose
CHARACTER_LENGTH() is a synonym of CHAR_LENGTH().
Examples
obclient> SELECT CHARACTER_LENGTH('CN'), LENGTH('CN'),CHARACTER_LENGTH('hello');
+----------------------------+------------------+---------------------------+
| CHARACTER_LENGTH('CN') | LENGTH('CN') | CHARACTER_LENGTH('hello') |
+----------------------------+------------------+---------------------------+
| 2 | 6 | 5 |
+----------------------------+------------------+---------------------------+
1 row in set