3 Replies Latest reply on Aug 29, 2004 2:24 AM by roohy

    connecting MySQL & unicode problem

    remohammadi

      I had setted my jboss too work with mysql, but I have a problem,
      for Using unicode in connection I think I should have a mysql-ds.xml like this (other configurations for mySQL in done) :


      <local-tx-datasource>
      <jndi-name>MySQLDS</jndi-name>
      <connection-url>jdbc:mysql://localhost/Librarian2?characterEncoding=utf8&useUnicode=true</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>user</user-name>
      password
      <security-domain>MySqlDbRealm</security-domain>
      </local-tx-datasource>


      the problem is "&" in <connection-url>...characterEncoding=utf8 & useUnicode=true
      whene the & in there, jboss can't parse it and whene useUnicode=true or characterEncoding=utf8 is not there, The database connection is not unicode,
      Please help me;
      Thanks, Reza.