• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC with Chinese Traditional (SQL Server)

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
     
    Ranch Hand
    Posts: 32
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
    Posts: 32
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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.
     
    reply
      Bookmark Topic Watch Topic
    • New Topic