-
1. Re: MySql and Euro Symbol
aloubyansky Oct 10, 2002 11:40 AM (in response to traxxoo)Can you store that symbol using direct sql in some sql-client?
-
-
3. Re: MySql and Euro Symbol
aloubyansky Oct 11, 2002 2:49 AM (in response to traxxoo)So, it's not lost when you fetch it from entity. Then you should change the encoding before displaying the text, I guess.
-
4. Re: MySql and Euro Symbol
traxxoo Oct 11, 2002 4:54 AM (in response to traxxoo)Hi all,
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 :
props.put("characterEncoding", "ISO-8859-1")
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 ?
Thanks !! -
5. Re: MySql and Euro Symbol
traxxoo Oct 11, 2002 4:58 AM (in response to traxxoo)Sorry, I would like to said :
props.put("useUnicode", "true");
I don't need characterEncoding prop.