I am writing a servlet to get the comment from the web. After they summit the comment, I will convert the comment from UTF-8 to Unicode, then display the comment immediatly and then save it into the database through Jdbc:Odbc. However, somthing's wrong:
1. The comment displayed immediately is correct. I can see the chinese character.
2. But, the character saved in Access is changed to be '??'
I have tried many ways to solve it. First, I try to type some chinese characters in Access directly, and it is OK. Second, I try to change the platform to Chinese Windows 98 and something more strange happen:
Sometimes, the chinese character can be saved in the DB correctly, but sometimes, a SQLException occur. It said that the update query is with wrong syntax. (It works fine with English words)