COLLATION_CHARACTER_SET_APPLICABILITY - xiaoboluo768/mysql-system-schema GitHub Wiki
- 该表提供查询MySQL Server中哪种字符集适用于什么校对规则。查询结果集相当于从SHOW COLLATION获得的结果集中的前两个字段值。该表其实并没有太大作用
- 该表是Memory引擎临时表
- 表定义语句
CREATE TEMPORARY TABLE `COLLATION_CHARACTER_SET_APPLICABILITY` (
`COLLATION_NAME` varchar(32) NOT NULL DEFAULT '',
`CHARACTER_SET_NAME` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8- 字段含义如下：
- COLLATION_NAME：校对规则名称
- CHARACTER_SET_NAME：校对规则对应的字符集名称
- 表记录完整字段内容示例
admin@localhost : information_schema 03:32:28> select * from COLLATION_CHARACTER_SET_APPLICABILITY limit 20;
+-------------------+--------------------+
| COLLATION_NAME | CHARACTER_SET_NAME |
+-------------------+--------------------+
............
| latin1_swedish_ci | latin1 |
| latin1_danish_ci | latin1 |
| latin1_german2_ci | latin1 |
| latin1_bin | latin1 |
| latin1_general_ci | latin1 |
| latin1_general_cs | latin1 |
| latin1_spanish_ci | latin1 |
| latin2_czech_cs | latin2 |
| latin2_general_ci | latin2 |
+-------------------+--------------------+
20 rows in set (0.00 sec)上一篇：COLLATIONS表 |下一篇：COLUMNS表