Problem upgrading Connector/J from 3.1.12 to 5.1.6

[Joni Rannila]

Hello. I've been trying to upgrade the mysql connector for a web application and it works fine except for one thing: The character en dash ('–') and some other special characters stored in db are converted in to ? in web pages and also the same special characters stored in the db by the new connector are replaced by the character '?'. When I changed back to the old connector, the old data came out fine, but the data inserted by the new connector is still showing the special characters as a question mark.

Every layer in the application is configured to use latin1. And the only change made is the upgrade of the connector.

I tried different settings to characterEncoding-variable, but nothing seems to work.

Help would be really appreciated.

- Joni