JDBC with Chinese Traditional (SQL Server)

[Amit Kapur]

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

Properties props = new Properties();
props.put("user", "sa");
props.put("password", "");
props.put("charSet", "Big5");
try{
Class test = Class.forName("jdbc :o dbc:amit");
con = DriverManager.getConnection("sun.jdbc.odbc.JdbcOdbcDriver", props);
}

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 ]

[Andrew Och]

Dear Amit

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

[Andrew Och]

Oh found this, but since you original posting is quite old I am sure you have solved your issue.

http://java.sun.com/j2se/1.3/docs/guide/intl/faq.html

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.