Question

What is the difference between MySQL LENGTH() and CHAR_LENGTH() function?

Answer 1

Answers. 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 cha