Skip to content

Instantly share code, notes, and snippets.

@jeanmonod

jeanmonod/Check_columns.sql

Created July 21, 2011 08:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeanmonod/1096807 to your computer and use it in GitHub Desktop.
Save jeanmonod/1096807 to your computer and use it in GitHub Desktop.
Download ZIP
Convert MYSQL DB to Unicode
Raw
Check_columns.sql
mysql -e "SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM information_schema.COLUMNS where COLLATION_NAME != 'utf8_unicode_ci' AND TABLE_SCHEMA='your_database_name';"
Raw
Check_tables.sql
mysql -e "SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_COLLATION != 'utf8_unicode_ci' AND TABLE_SCHEMA='your_database_name';"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment