What is the difference between CHAR_LENGTH and LENGTH?

The first is 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 encoding.

Differentiate CHAR_LENGTH and LENGTH ?

CHAR_LENGTH  is character count whereas the LENGTH is byte count. The numbers are same for Latin characters but they are different for Unicode and other encodings.