Changing MySQL default character sets (latin) to UTF-8
Method: Export then Import
- Back up the database via a phpmyadmin export - SQL (phpMyAdmin 2.2.3 in old version)
- Save this file.
- Replace “CHARSET=latin1” to “CHARSET=utf8”. -> (“latin1_swedish_ci” to “utf8_general_ci”)
- Convert to UTF-8 without BOM in Notepad++
- Save this file, and use phpmyadmin to import it. (import in new version - phpMyAdmin)