Even though all default settings include “utf8-general-ci” every newly created database keeps getting that “swedish” collation and character set! So one way to convert to utf8 is to go table by table and type the SQL command: ALTER TABLE dbase.table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci where ‘dbase’ is the name of the database […]
