JDBC Connector and Character Sets

[Stephen Rothwell]

Hi,

I have come across a problem. I have just deployed an application that reads from a database and sends some text messages. On the test environment it works fine but on the production a £ sign comes out corrupted B£.

I have checked the logs and the data is coming from the db corrupted. I am assuming this is a character set problem on the production server but dont know how to integregate mysql to find out what is happening.

I am certain this is an easy question to answer for those experienced with MySQL.

I have the latest JDBC connectors and the configuration is identical. I do not pass any character set info in the connection string.

Any help greaftully received.

Steve