aspose file tools
The moose likes JDBC and Relational Databases 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 Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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)