Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: how to swap database characters encoding...


Advanced Search

how to swap database characters encoding...
Posted by: Patrick Gelin ()
Date: May 12, 2012 05:47AM

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

Options: ReplyQuote


Subject Written By Posted
how to swap database characters encoding... Patrick Gelin 05/12/2012 05:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.