Can you store that symbol using direct sql in some sql-client?
Yes, I can !
So, it's not lost when you fetch it from entity. Then you should change the encoding before displaying the text, I guess.
I made a test just by quering directly with a jdbc connection. The problem is the same, the euro symbol is not dislayed.
If I use DriverManager.getConnection with a Properties parameter and I add the following prop :
The euro symbol is corectly extracted with from the database !
So, how to add this prop in the jbdc connection in JBoss ? If I add this line in the mysql-service.xml (just after the password) :
<config-property name="useUnicode" type="java.lang.String">true</config-property>
The following exception is thrown :
The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'useUnicode'
Any Idea ?
Sorry, I would like to said :
I don't need characterEncoding prop.