Re: charset/mysqldump bug?

[Samuel GAY]

Hi,

I've *exactly* the same trouble as kennylucius with MySQL 5.0.22 on Ubuntu 6.06. An unknown character set with a simple mysqldump. All seems to be ok, except with mysqldump.

It seems like if mysqldump considers charset source as latin1, an try to convert it to utf8. But database is utf8, table utf8, column utf8... Like you if I add "--default-character-set=latin1" all is good... in utf8 !

Here are some variables :

| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | BINARY |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | latin1_swedish_ci |


I really don't understand why, and why just mysqldump. Can anybody help us ?
Thanks.
Sam.