Skip to content

Instantly share code, notes, and snippets.

@piotch

piotch/encodings.sql

Created August 12, 2014 15:30
Show Gist options
  • Save piotch/cad81645286892fdea0d to your computer and use it in GitHub Desktop.
Save piotch/cad81645286892fdea0d to your computer and use it in GitHub Desktop.
Download ZIP
Show all tables encodings
Raw
encodings.sql
SELECT
COLUMN_NAME,
TABLE_NAME,
CHARACTER_SET_NAME,
COLUMN_TYPE,
COLLATION_NAME
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment