how to swap database characters encoding...

[Patrick Gelin]

Hi,

I'm using a mysql database with utf_general_ci interclassement but it's wrong, what I need is latin1 (iso-8859-1) (West Europe). I would like to use mysqldump to export with latin1 like this :

C:\EasyPHP5.2.10\mysql\bin>mysqldump -u bibli -pXXXX --default-character-set=latin1 bibli > bibli.sql

But the bibli.sql result file show tables with (ENGINE=MyISAM DEFAULT CHARSET=utf8; ). So the character encoding seems not working... Could you please tell me what is wrong or explain me how to modify chartacter encoding for a database ?

Thank you.
Patrick