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)