File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes database operation with other character set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "database operation with other character set" Watch "database operation with other character set" New topic
Author

database operation with other character set

Jeff Guo
Greenhorn

Joined: Mar 16, 2001
Posts: 6
I am chinese guy, and my OS(WinNT4) is a Simple Chinese version, so the default zone is Chinese(RPC). Now, I wanna to insert a record into database(MS SQL7.0), the value is a chinese word delivered by a variable. but ODBC always return error, and most situation the error message is 'error syntax' near xxxx(chinese word). how can I do it. whether I need to change the character set before execute my SQL.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: database operation with other character set
 
Similar Threads
JBoss Language problem
Reading chinese characters through java input fields
Need to store the Chinese character in the Java String variable from the ResultSet
Reading chinese characters through java input fields
Update XML to CLOB