Forums Register Login

JDBC ODBC driver with chinese character

+Pie Number of slices to send: Send
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
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1551 times.
Similar Threads
NON-English chars become "???" when inserting data
JDBC with Chinese Traditional (SQL Server)
MS SQL Server 7
please, help !
JBuilder -->SQL Server2000 Chinese display problem, HELP NEEDED!
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 18, 2024 21:31:33.