Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

does freetds support Chinese with MSSQL?

843854Jan 27 2003 — edited Jan 27 2003
does freetds support Chinese with MSSQL?
I have a ms sqlserver 7, having Chinese data stored in database. I want to access the database using pure-java jdbc driver.

I have searched the forum. no one can give a proper solution to the problem.

I download freetds driver. Use jdbc connection string like this: "jdbc:freetds:sqlserver://servername/database;CHARSET=cp936;TDS=7.0".
Chinese code page is CP936. but when I connect to ms sqlserver successfully, and get result set successfully, access the field value containing no Chinese successfully, but the field value containing Chinese characters is error-coded.

Is that freetds does not support Chinese? or the jdbc connection string is male-formed?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2003
Added on Jan 27 2003
1 comment
298 views