File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Loading Chinese characters  into Oracle" Watch "Loading Chinese characters  into Oracle" New topic

Loading Chinese characters into Oracle

sridhar Ranganathan

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

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:
subject: Loading Chinese characters into Oracle
It's not a secret anymore!