collation-character-set-applicability.md

COLLATION_CHARACTER_SET_APPLICABILITY

COLLATION_CHARACTER_SET_APPLICABILITY 表示了每个排序规则适用的字符集。

USE INFORMATION_SCHEMA;

SELECT * FROM COLLATION_CHARACTER_SET_APPLICABILITY;

结果如下：

+----------------+--------------------+
| collation_name | character_set_name |
+----------------+--------------------+
| utf8_bin       | utf8               |
+----------------+--------------------+

结果中的列：

• collation_name：排序规则名称。
• character_set_name：与排序规则关联的字符集名称。