Re: Problems with character

[Ingo Strüwing]

Hi,

I cannot repeat it with 5.0.19 on Linux. It works.

Is it possible that the truncation happens on the client side? Which tool(s) did you use to check this.

I tried with the 'mysql' command line client:
mysql> insert into test values('cliché');
mysql> select name,char_length(name),length(name) from t1;
+--------+-------------------+--------------+
| name | char_length(name) | length(name) |
+--------+-------------------+--------------+
| cliché | 6 | 7 |
+--------+-------------------+--------------+

You can see that the 'é' is stored as two bytes internally, which is correct for UTF-8.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com