Skip to content

Instantly share code, notes, and snippets.

@simonw

simonw/show_mysql_tables_and_charsets.sql

Created July 20, 2011 13:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save simonw/1094933 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save simonw/1094933 to your computer and use it in GitHub Desktop.
Download ZIP
Show MySQL tables and their charsets
Raw
show_mysql_tables_and_charsets.sql
SELECT
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
AND T.table_schema = "YOUR_DB_NAME";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment