This statement will convert a mySQL schema to uft8_unicode_ci including tables and columns. SELECT CONCAT(“ALTER TABLE “, TABLE_NAME,” Convert to CHARACTER SET utf8 COLLATE utf8_unicode_ci;”) AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=”myDatabaseName” AND TABLE_TYPE=”BASE TABLE”
Alter mySQL collation
