Latest snippets tagged utf8http://snippets.prendreuncafe.com/snippets/tagged/utf8/order_by/date2008-02-27T16:28:28ZSymfonynoreply@symfony-project.comExport/Import d'une base MySQL utf82008-02-27T16:28:28Z74C'est pas facile, mais c'est possible.
I. Exportation de la base :
[code]
$ mysqldump -uuser -p --opt --default-character-set=utf8 mabase > mabase.sql
[/code]
II. Reconversion :
[code]
$ iconv -f iso-8859-1 -t utf-8 mabase.sql > mabase_utf8.sql
[/code]
III. Reimport :
[code]
$ mysql -uuser -p mabase < mabase_utf8.sql
[/code]