[SOLVED] : Mysql ISO kai UTF8

[Dimitris Mexis]

Se afto to link tha vreite tis plirofories pou vrika
http://padawan.info/weblog/converting_a_movable_type_blog_from_iso-8859-1_to_utf-8.html

se genikes grammes thelei:

1) mysqldump --default-character-set=latin1 -C -u username -p -h host
--opt --skip-add-locks --skip-extended-insert database > mtdump.sql
afto to lati1, ithele para poli prosoxi, giati eno ekana to export opos
eixame pei oute kan iso8859-7 den exigage i vasi sto mtdump.sql

2) iconv -f iso-8859-7 -t utf-8 mtdump.sql > mtutf8.sql

3) mysql -u username -p --default-character-set=utf8 database < mtutf8.sql
Tora afto menei na kano gia na ta xanaeisago. Mikro to kako pia :-)

Sas efharisto pedia.