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