How to insert Chinese characters in Oracle DB using Java

Question

I need to insert Chinese characters inside Oracle Data base using Java (hibernate 3.0 /jpa), I tried many methods and failed.

When I persist the entity I see (??? ) in the filed and when I retrieve the value I see the same result.

My Oracle NLS_DATABASE_PARAMETERS:

NLS_CHARACTERSET   WE8MSWIN1252
NLS_NCHAR_CHARACTERSET  AL16UTF16

The column type is Nvarchar. I set this properties in persistence.xml

<property name="hibernate.connection.useUnicode" value="true"  />
<property name="hibernate.connection.characterEncoding" value="UTF-8"/>
<property name="hibernate.connection.charSet" value="UTF-8"/>

Codo · Accepted Answer · 2012-06-18 12:03:09Z

2

If you have the chance, then convert your database from the character set WE8MSWIN1252 to AL32UTF8 (which is the default for new Oracle installations). Then all your problems will be gone and you don't need to use problematic data types like NCHAR or NVARCHAR or any special connnection settings.

answered Jun 18, 2012 at 12:03

Codo

79.7k18 gold badges176 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajat Saini · Accepted Answer · 2012-06-18 10:25:56Z

1

I had the same problem in SQL server and there we solved it by converting all the varchar fields to nvarchar. Also all the corresponding store procedures and return types need to be changed. Make sure all you procedures also have nvarchar datatype

answered Jun 18, 2012 at 10:25

Rajat Saini

5577 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to insert Chinese characters in Oracle DB using Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related