$ mysqldump –default-character-set=latin1 –databases wordpress > m.sql
$ replace “CHARSET=latin1″ “CHARSET=utf8″ \
“SET NAMES latin1″ “SET NAMES utf8″ < m.sql > m2.sql
$ mysql < m2.sql
wp-config.php:
define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);
atppp’s Blog » Convert WordPress database from Latin1 to UTF-8