Skip to content

Instantly share code, notes, and snippets.

@buithehoa

buithehoa/show-mysql-database-character-set-and-collation.mysql

Last active August 29, 2015 14:26
Show Gist options
  • Save buithehoa/c4c87772dc2200684a67 to your computer and use it in GitHub Desktop.
Save buithehoa/c4c87772dc2200684a67 to your computer and use it in GitHub Desktop.
Download ZIP
Show MySQL database character set and collation
Raw
show-mysql-database-character-set-and-collation.mysql
SELECT @@character_set_database, @@collation_database;
# OR
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment