permaculture playing cards
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
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!