Hi all,
We are currently using Hibernate and Spring on top of the standard NWCloud instance. We are finding that when we insert the character "£" into the database using JPA we are getting "£" actually stored, similarly if we attempt to insert "€" we get "€". (The field is generated automatically by the JPA, and is a VARCHAR(255))
This is clearly a character encoding issue somewhere along the line, but I was wondering if anyone else had met this problem and found a solution?
In the persistence.xml we have set
<property name="hibernate.connection.charSet" value="UTF-8"/>
<property name="hibernate.connection.useUnicode" value="true"/>
<property name="hibernate.connection.characterEncoding" value="UTF-8"/>
But this hasn't changed the values that we are seeing put into the database.
Thanks for your help in advance,
Gareth