Workaround: Re: weird mysql problem on linux, international chars truncates varchar

[Ryan Thompson]

Continuing with the previous test case, I have found that adding an explicit cast to CHAR fixes the problem.

However, shouldn't the result of the CHAR() function always be a CHAR?

mysql> insert into test.cc values(concat('test',cast(char(conv(8365,16,10)) as char),'スト'));
Query OK, 1 row affected (0.00 sec)

mysql> select * from test.cc;
+------------+
| a |
+------------+
| test |
| testテスト |
| testテスト |
+------------+
3 rows in set (0.00 sec)