What is the string length function in MySQL?
1. LENGTH(str) returns the length of the string in bytes.
2. CHAR_LENGTH(str) returns the character count of the string. The difference occurs when multibyte (such as UTF-8) characters are used.
For example, length('aä') will return 3, while char_length('aä') will return 2.