Accessing chinese characters from database(SQLServer2000) using jdbc

[shylaja]

Hi
I have a query regarding accessing chinese characters from database(SQL Server) using JDBC.
I have a flat file which contains chinese characters.I have imported that flatfile as a table in SQLServerDatabase.
Iam trying to access the values through a simple JDBC Program.While displaying the values are not retrieved properly.Certain characters are displayed as garbage values.
I have also tried converting the string based on different character sets suported by java.
If anyone has some idea how to reproduce the chinese characters from sql database using jdbc please do help

Thanks in Advance
shylaja

 

[JVZ]

I'm not sure if this can help you out or not...but I found this webpage that talks about this topic..

http://www.geocities.com/siufai6/java/JDBC_Chinese.html

If this doesn't help you let me know I'll see what else I can find.