Cannot update Chinese character in utf8 to mySQL with java

[Kin Yeung]

Hi all,

I m using mysql server 5.0 with connector j (version 5.0.4) to create a web-based program. I have a problem which I cannot store / update chinese character via my program.

I can run my program and stored english characters, but not chinese character. my program is running in tomcat and i can read my chinese character in the tomcat log file. However, the output of my program always shows me ????? if the value is in chinese. Even I use phpmyadmin, it also shows me ????. I think I cannot stored chinese character with my program.

But when I use phpmyadmin (the php one), it can store chinese character and retrieve it in my program.

My collaction of my database, table, and the relative field are utf_general_ci, I tried to change it to utf_unicoe_ci, they are they same.

Please assists.
Thanks a lot


Regards,

Kin