Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#java-database-connectivity-jdbc
1 comment
246 views