这个专题主要讲information_schema数据库下的一些表 如无特殊说明数据库版本为MySQL 5.7.26 **COLLATION_CHARACTER_SET_APPLICABILITY** 该表指出字符集适合什么排序规则 有如下栏位 - COLLATION_NAME 排序规则的名称 - CHARACTER_SET_NAME 排序规则相关的字符集的名称 该表和COLLATIONS表的前2个栏位一致 **实际截图** ``` SELECT * FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY; SELECT * FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE COLLATION_NAME LIKE '%utf8%'; ``` [image:805 size:orig] 或者 ``` SHOW COLLATION; SHOW COLLATION like '%utf8%'; ``` [image:806 size:orig] COLLATION_CHARACTER_SET_APPLICABILITY 表的内容和上面命令的前两列相同 **参考链接** [https://dev.mysql.com/doc/refman/5.7/en/collation-character-set-applicability-table.html](https://dev.mysql.com/doc/refman/5.7/en/collation-character-set-applicability-table.html)