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 ]