How to configure MySQL to support Big5 encoding in JBoss?

[ucftcys]

Hi,
Could anyone tell me how to configure MySQL to support Big5 encoding in JBoss?
In order to make MySQL to support Big5 encoding, two attributes need to be added after the url, for example,jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=Big5
How can I add the two values in JBoss??

[davidjencks]

Well, did you try adding them at the end of the ConnectionURL you specify?

[ucftcys]

Yes. I've tried...but JBoss throws an exception...
org.jboss.deployment.DeploymentException: Exception getting document; - nested t
hrowable: (org.xml.sax.SAXParseException: 下一個字元必須是 ";" 終止參照實體 "cha
racterEncoding"。)

It seems that I cannot add the two attributes after the connectionURL...does anyone knows where to put the two values??

[fbiaggi]

Use:
"jdbc:mysql://127.0.0.1:3306/mydb?autoReconnect=true&useUnicode=true"

[fbiaggi]

sorry, decoded,
use & amp ; useUnicode=true without spaces

[ucftcys]

Thanks a lot....It works....excellent~~~