SELECT * from information_schema.TABLES where TABLE_SCHEMA!=’performance_schema’ and TABLE_SCHEMA!=’sys’ and TABLE_SCHEMA!=’information_schema’ and TABLE_SCHEMA!=’mysql’ and TABLE_COLLATION!=’utf8mb4_unicode_ci’;
SELECT table_schema, table_name, column_name, character_set_name, collation_name
FROM information_schema.columns
WHERE collation_name != ‘utf8mb4_unicode_ci’ and TABLE_SCHEMA!=’performance_schema’ and TABLE_SCHEMA!=’sys’ and TABLE_SCHEMA!=’information_schema’ and TABLE_SCHEMA!=’mysql’
ORDER BY table_schema, table_name,ordinal_position;