SELECT T.TABLE_SCHEMA, T.table_name, CCSA.character_set_name
FROM information_schema.TABLES T, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA
WHERE CCSA.collation_name = T.table_collation
ORDER BY T.TABLE_SCHEMA;