Force mysqldump encoding

view story

http://unix.stackexchange.com – I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same : $ mysql -h right_server -NBe "SHOW VARIABLES LIKE 'character_set_%'" $ mysql -h wrong_server -NBe "SHOW VARIABLES LIKE 'character_set_%'" give same results : character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server utf8 character_set_system utf8 I use mysqldump to check tables structures are the same : (HowTos)