Hi all I am having problems using JDBC (JDK 1.3) when I am trying to update my database (SQL Server) with certain Chinese Charaters. I am trying to update data in a table with non-Unicode datatype (varchar) and some characters are giving problem (characters with character codes 29054, 29055, etc). The JDBC Connection with Data base was obtained using
But for the special characters i mentioned before it is not updating the table correctly but shows question marks (?) instread. Well I have no problems with SQL Server Internationalization since I am able to add data (including the special characters I mentioned in my question earlier) in the SQL tables through the query analyser. My problem basically is that I have not been able to add those special characters via my web application (JSP/Java Bean). With regard to the problem lemme give u some more information
Unicode data types are nchar, nvarchar and ntext. Non-Unicode data types are char, varchar and text.
I am already using a Chinese Windows Machine (Win 2K Adv server) and so already have the Chinese Trational (Tiawan) Locale (zh_TW).
Now I am trying to go on with Unicode Encoding (UTF-8) but till now haven't found the solution.
If someone has some idea about using Chinese Traditional with JDBC please help. Any Help would be welcome Regards Amit Kapur [ April 27, 2003: Message edited by: Amit Kapur ]
Joined: Mar 19, 2004
I had a similar problem with chinese character fonts showing an occasional question mark (?) on windows. I fixed the problem by install all chinese language support ie Chinese tradional and chinese simplied.
I stumbled across you question because I am stuck with storing chinese unicode characters in MySQL and wondered how you were storing them in SQL server. Do you have values like "\u4F60\u597D" which when I add to a string and drawString( ) then it prints Ni Hao but if I get this value from MySQL it just draws \u4F60\u597D.
Best regards Andrew
Joined: Mar 19, 2004
Oh found this, but since you original posting is quite old I am sure you have solved your issue.
Sun's Java 2 SDK and Runtime Environment version 1.3.0 for Windows had two serious bugs affecting Traditional Chinese:
* The Swing dialogs and the output of several tools, including the javac compiler, show up as a mix of Chinese characters and question marks (bug 4339627). * In the Plugin control panel, Chinese characters are rendered in such poor quality that the text is illegible (bug 4346273).
These bugs have been fixed since version 1.3.0_01.
subject: JDBC with Chinese Traditional (SQL Server)