Show the character set and the collation of your MySQL tables

SHOW TABLE STATUS FROM test;
SHOW FULL COLUMNS FROM table_name;
SHOW CREATE TABLE foobar;
USE mydatabase;
SHOW VARIABLES LIKE 'character_set_database';
SHOW VARIABLES LIKE 'collation_database';
SHOW VARIABLES;