Re: CHAR_LENGTH() returns incorrect value on Japanese UTF8 text

[G P]

Yes I get the same problem. Also　if I try to insert 20 characters it truncates them

mysql> INSERT INTO multibyte (thing) VALUES('はははははははははははははははははははは');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> SELECT thing, CHAR_LENGTH(thing), LENGTH(thing) FROM multibyte;
+----------------------+--------------------+---------------+
| thing | CHAR_LENGTH(thing) | LENGTH(thing) |
+----------------------+--------------------+---------------+
| human | 5 | 5 |
| ははは | 9 | 18 |
| ははは | 9 | 18 |
| はははははは�� | 20 | 40 |
+----------------------+--------------------+---------------+