No ascii characters from java

[michael Mauro]

Hi all,

i'm working on a java software communicating with a mysql db.

The java software is using the default character encoding, i have some troubles when i have to do queries on db with spanish characters (as Ñ).

From the java code i call a stored procedure and i give as parameter the string that has to be used in the research on db.

The issue comes out when i use spanish characters because java translates them in hexadecimal values and put this value as string in the query (Using a simple setString() on a CallableStatement).

So instead do a query with Ñ% as parameter i have a query with C391%.

Is there a way to fix this problem from db side?

ps:

I'm using mysql 5.5 and the mysql library for java is "mysql-connector-5.1.38.jar"

Thanks in advance