Change all CHARACTER SETs in a Mysql database.sql

Change_all_CHARACTER_SET_in_a_Mysql_database.sql

-- This pull back a list of tables which have NON-UTF8 encoded columns and creates a SQL script to fix them (and the table itself)
SELECT CONCAT("ALTER TABLE ",t.TABLE_SCHEMA,".",t.TABLE_NAME," CHARACTER SET utf8 COLLATE utf8_general_ci;",
    "ALTER TABLE ",t.TABLE_SCHEMA,".",t.TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;") 
    AS sql_to_copy_and_run
FROM information_schema.TABLES t
INNER JOIN information_schema.`COLUMNS` c ON t.TABLE_SCHEMA = c.TABLE_SCHEMA
WHERE
  t.TABLE_SCHEMA = ?  -- Replace ? with your Database/Schema name
  AND t.table_type = 'BASE TABLE' AND character_set_name IS NOT NULL AND character_set_name <> 'utf8'
GROUP BY t.TABLE_SCHEMA, t.TABLE_NAME