Re: Problem with connecting to MySQL server

[Pascal LAVAUX]

I have the same problem using MySQL 5.1.40 with Connector/J 5.1.10 (or 5.1.7) and Tomcat 6.0.20 on OS DEBIAN 5.03 (LANG=fr_FR.UTF-8).

If I put in the my.cnf file the 2 lines
collation_server=utf8_general_ci
character_set_server=utf8

Tomcat connect to MySQL, but the requests return bad values, because, I think, I'm using a latin1 base.

If I put in the my.cnf file the 2 lines (or none)
collation_server=latin1_general_ci
character_set_server=latin1

I have the error Cannot create PoolableConnectionFactory ...

Any idea (how did you solve it ? Thanks

Pascal