Question

length() vs char_length() in MySQL?

Answer 1

LENGTH() returns the length of the string measured in bytes. CHAR_LENGTH() returns the length of the string measured in characters. As you can see the Euro sign occupies 3 bytes (it's encoded as 0xE282AC in UTF-8) even though it's only one character.