The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table : INFORMATION_SCHEMA : Data Dictionary MySQL TUTORIALS

MySQL TUTORIALS » Data Dictionary » INFORMATION_SCHEMA »

The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table

The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation.

The columns are equivalent to the first two display fields that we get from SHOW COLLATION.


mysql> desc INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY;
+--------------------+-------------+------+-----+---------+-------+
| Field              | Type        | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| COLLATION_NAME     | varchar(64) | NO   |     |         |       |
| CHARACTER_SET_NAME | varchar(64) | NO   |     |         |       |
+--------------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)