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 Loading Chinese characters  into Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Loading Chinese characters  into Oracle" Watch "Loading Chinese characters  into Oracle" New topic
Author

Loading Chinese characters into Oracle

sridhar Ranganathan
Greenhorn

Joined: Feb 06, 2008
Posts: 29
I am trying to load chinese characters into Oracle 9i using Java.

I am using Preparestatement to load the values.
Have set the DB which can handle chinese language.
I am using the following statement to set the chinese string.

preparedStatement.setObject(i, "邮箱大小为");

The datatype in the table and the paramtype configured are nvarchar.

The value gets loaded as "???".

However when i try to manually insert the field with the following query i am able to successfully load.

Insert into china (Name) values ('邮箱大小为')

Any help please!!!
Nitesh Kant
Bartender

Joined: Feb 25, 2007
Posts: 1638

I just googled and found this thread. This may give you a kickstart.


apigee, a better way to API!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Loading Chinese characters into Oracle