LENGTH(str): Returns the length of the string str, measured in bytes : LENGTH « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. LENGTH

For a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.

OCTET_LENGTH() is a synonym for LENGTH().

SELECT LENGTH('text');


mysql>