aspose file tools*
The moose likes JDBC and the fly likes JDBC with Chinese Traditional (SQL Server) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC with Chinese Traditional (SQL Server)" Watch "JDBC with Chinese Traditional (SQL Server)" New topic
Author

JDBC with Chinese Traditional (SQL Server)

Amit Kapur
Greenhorn

Joined: Feb 01, 2002
Posts: 2
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 ]

    AK
    Andrew Och
    Ranch Hand

    Joined: Mar 19, 2004
    Posts: 32
    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
    Ranch Hand

    Joined: Mar 19, 2004
    Posts: 32
    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.
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: JDBC with Chinese Traditional (SQL Server)