LENGTH(str)
LENGTH(str) mysql function returns the length of the string str, measured in bytes. This function counts a multibyte character as multiple bytes. hence it means for a string containing 4(four) 2-byte characters then LENGTH() returns 8, whereas CHAR_LENGTH() returns 5.
Here is some example which will explain you clearly-
mysql> SELECT LENGTH('Hello MySQL');
+-----------------------+
| LENGTH('Hello MySQL') |
+-----------------------+
| 11 |
+-----------------------+
1 row in set (0.00 sec)
mysql> SELECT LENGTH('123');
+---------------+
| LENGTH('123') |
+---------------+
| 3 |
+---------------+
1 row in set (0.00 sec)
0 Comment(s)