COLLATION_CHARACTER_SET_APPLICABILITY

• 该表提供查询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表