Hibernate Oracle and Character Encoding

Question

Im having an issue at the moment where my testing environment is not persisting the trademark character "™" in the database. When I enter in the form data, then submit it, I can see that on the server side, the request has the correctly encoded ™ character, but then when the call to hibernate's "saveOrUpdate()" method is called, the data in the table shows up as an upside down question mark.

Im using SqlDeveloper to inspect the table, and I can manually change the character to a ™ by pasting directly into the row then committing, and it works.

So I have made the assumption that hibernates methods of persistence are not working correctly.

Im at a loss here, really, I just dont know what to try, I have set the:

<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">utf-8</property>

properties in the config file, with no luck.

My columns in the tables are NVARCHAR2(400 CHAR) (although they were originally, just VARCHAR2 to start with, but I changed them during the debugging of this issue).

Any help here is greatly appreciated.

Mark

Pavel Ryzhov · Accepted Answer · 2016-01-08 13:01:41Z

5

Ok, so it turns out that what I needed to do was to set the defaultNChar connection property to true.

I did this via the context file for my app in Tomcat.

The article that enlightened me was here.

edited Jan 8, 2016 at 13:01

Pavel Ryzhov

5,2328 gold badges54 silver badges73 bronze badges

answered Aug 3, 2009 at 23:45

Mark

15k17 gold badges104 silver badges161 bronze badges

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

2 Comments

Jigar Shah Over a year ago

Hi MArk, we are not using NCHAR but we are facing issue with Nordic character. They are part of ISO-8859-1. It seems while writing into database it does some magic.

xenoterracide Over a year ago

link is now dead... :(

Collectives™ on Stack Overflow

Hibernate Oracle and Character Encoding

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related