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


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.

Options: ReplyQuote

Written By
how to swap database characters encoding...
May 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.