Hi, This my script to convert latin1 database to utf8 :
$ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydatabase.latin1.sql $ sed -e 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ iconv -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo "SET NAMES utf8;" > tmp.sql $ cat mydatabase.utf8.sql >> tmp.sql $ mv tmp.sql mydatabase.utf8.sql I've one question : * if my database have some blob field with binary data (like image...), iconv convert also this data then this data will be corrupted ? Thanks for your information, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
