COLLATION_CHARACTER_SET_APPLICABILITY
COLLATION_CHARACTER_SET_APPLICABILITY 表将排序规则映射到适用的字符集名称。与 COLLATIONS 表类似，它仅为兼容 MySQL 而包含。
USE INFORMATION_SCHEMA;
DESC COLLATION_CHARACTER_SET_APPLICABILITY;
输出如下：
+--------------------+-------------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------+------+------+---------+-------+
| COLLATION_NAME | varchar(32) | NO | | NULL | |
| CHARACTER_SET_NAME | varchar(32) | NO | | NULL | |
+--------------------+-------------+------+------+---------+-------+
2 rows in set (0.00 sec)
在 COLLATION_CHARACTER_SET_APPLICABILITY 表中查看 utf8mb4 字符集的排序规则映射：
SELECT * FROM COLLATION_CHARACTER_SET_APPLICABILITY WHERE character_set_name='utf8mb4';
输出如下：
+--------------------+--------------------+
| COLLATION_NAME | CHARACTER_SET_NAME |
+--------------------+--------------------+
| utf8mb4_bin | utf8mb4 |
| utf8mb4_general_ci | utf8mb4 |
| utf8mb4_unicode_ci | utf8mb4 |
+--------------------+--------------------+
3 rows in set (0.00 sec)
COLLATION_CHARACTER_SET_APPLICABILITY 表中列的说明如下：
COLLATION_NAME：排序规则的名称。CHARACTER_SET_NAME：排序规则所属的字符集名称。