MySQL: fixing double-encoded UTF-8 data
Ever have double-encoded UTF-8 data in your MySQL database? Of course you have. Here’s a handy trick to quickly remedy that sticky situation, via MySQL command-line tools:
mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql
mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql
That’s it! No scripts required.
Source: Odd, Even, Odd, Even…
