Skip to content

Instantly share code, notes, and snippets.

@oak-tree

oak-tree/gist:6fadc29cf852a3f874eb

Created August 26, 2014 10:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oak-tree/6fadc29cf852a3f874eb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oak-tree/6fadc29cf852a3f874eb to your computer and use it in GitHub Desktop.
Download ZIP
MySql: search for all tables and db with collation different than utf_8_general_c
Raw
gistfile1.txt
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLLATION_NAME != 'utf8_general_ci'
LIMIT 0 , 30
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment