Re: setting connection character set

[Thomas Taylor]

As per the MySQL/Connector/J manual, you can't use the 'SET NAMES' command after you've created your initial JDBC connection, the Connector/J driver does not receive this 'update'.

The recommended way to set the connection character set is through the JDBC connection URL. This is done by adding 'characterEncoding=<charset>' to your JDBC URL.

Example:
String URL = "jdbc:mysql://localhost/MyDatabase&characterEncoding=UTF-8";

Connection connection = DriverManager.getConnection(URL);