This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC ODBC driver with chinese character

 
Sumona Dev
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • 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

code:
--------------------------------------------------------------------------------
Properties props = new Properties();props.put("user", "sa");props.put("password", "");props.put("charSet", "Big5");try{Class test = Class.forName("jdbc 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
Sumona
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic