[jboss-user] [JCA/JBoss] - Special Portugese Characters cause queries to fail

[damo9f]

We are testing in Portugese and find that if a query condition contains "special" characters such as  ã  and  é  the query does not work properly.   HOWEVER if we use Hibernate Criterion the query works. 

 These characters have integer representations above 128, which may be relevant.

Deep in the query code (inside Hibernate) I see that the string in question does not show properly in the debugger when it is converted to a PreparedStatement.  That is, the string shows fine but the toString() on the PreparedSTatement has the chars in question replaced by the little box that indicates a character is unknown.

We are using MySQL 4.1 and mysql-connector-java-3.0.16-ga.jar with the following mysql-ds.xml


  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  |     <local-tx-datasource>
  | 	<jndi-name>MySqlDS</jndi-name>
  | 	<connection-url>jdbc:mysql://localhost:3306/imsma</connection-url>
  | 	<driver-class>com.mysql.jdbc.Driver</driver-class>
  | 	<user-name>imsma</user-name>
  | 	<password>password</password>
  | 	<min-pool-size>20</min-pool-size>
  | 	<max-pool-size>45</max-pool-size>
  |     </local-tx-datasource>
  | </datasources>
  | 

Can anyone help us diagnose this issue?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3984227#3984227

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3984227