什么是(默认的)字符集:

MySQL数据库 MySQL表 MySQL列


当前回答

数据库:

只需使用这些命令:

USE db_name;
SELECT @@character_set_database;
-- or:
-- SELECT @@collation_database;

其他回答

显示像'character_set_%'或'collation%'这样的变量

数据库:

USE your_database_name;
show variables like "character_set_database";
-- or:
-- show variables like "collation_database";

参考本页。查阅MySQL手册

对于表和列:

show create table your_table_name

列:

SHOW FULL COLUMNS FROM table_name;
SELECT TABLE_SCHEMA,
       TABLE_NAME,
       CCSA.CHARACTER_SET_NAME AS DEFAULT_CHAR_SET,
       COLUMN_NAME,
       COLUMN_TYPE,
       C.CHARACTER_SET_NAME
  FROM information_schema.TABLES AS T
  JOIN information_schema.COLUMNS AS C USING (TABLE_SCHEMA, TABLE_NAME)
  JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS CCSA
       ON (T.TABLE_COLLATION = CCSA.COLLATION_NAME)
 WHERE TABLE_SCHEMA=SCHEMA()
   AND C.DATA_TYPE IN ('enum', 'varchar', 'char', 'text', 'mediumtext', 'longtext')
 ORDER BY TABLE_SCHEMA,
          TABLE_NAME,
          COLUMN_NAME
;