Page Comparison

-- find columns with non-standard collations
SELECT 
   table_name,
   column_name, 
   character_set_name, 
   collation_name 
FROM information_schema.columns c
WHERE table_schema = 'superticker_dev'
and collation_name is not null and collation_name != 'utf8mb4_unicode_ci';