Alter mySQL collation

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”