buithehoa
8/2/2015 - 12:00 PM

Show MySQL database character set and collation

Show MySQL database character set and collation

SELECT @@character_set_database, @@collation_database;

# OR

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';