Difference between CHAR_LENGTH and LENGTH...

CHAR_LENGTH and LENGTH differences in MySQL...

We r testing both function and tried to generate different results for both.
Here is what v did:

mysql> select length(CONVERT('hallo' USING sjis) ) length, char_length(CONVERT('hallo' USING sjis)) char_length ;
+--------+-------------+
| length | char_length |
+--------+-------------+
| 5 | 5 |
+--------+-------------+
1 row in set (0.01 sec)

because LENGHT should give the length in bytes why are both results the same ?

Hi Sheetal,

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