Encontre todas as tabelas que possuem um agrupamento ou codificação não utf8

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE 
    COLLATION_NAME IS NOT NULL AND 
    COLLATION_NAME <> 'utf8_general_ci' AND 
    COLLATION_NAME <> 'utf8_unicode_ci' AND 
    COLLATION_NAME <> 'utf8_bin';