these are the settings my connection is using:
Server Character Set: latin1
Client Character Set: utf-8
Database Character Set: latin1
Table Engine: innoDB
Table Collation: latin1_Swedish_ci
Varchar collation: latin1_Swedish_ci
Connection collation: latin1_Swedish_ci