What’s the difference between CHAR_LENGTH and LENGTH?

Question

Hello
What’s the difference between CHAR_LENGTH and LENGTH?
please reply me. i am waiting for your reply.
Thanx

Answer 1

The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.