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;

发表评论

电子邮件地址不会被公开。 必填项已用*标注