MySQL 4.1. support UTF8
 

Hi! All,

I have a question that why the mysql db can't be support utf8 - chinese character set? I sure that the table setting is correct. Because the table setting can be work in window platform.

I wrote a java program which have a insert statement and I wrote the db connection (con = DriverManager.getConnection("jdbc:mysql:///db?useUnicode=true&characterEncoding=utf8",dbusername,dbpassword);). It work fine in window platform. I can see the chinese row in the table. But It can't work in Linux platform. WHy?

The Mysql is the same version for both OS!
I want to know is the OS would be affect the mysql character set?
Any idea?


Thks