The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table : INFORMATION_SCHEMA « Data Dictionary « MySQL Tutorial

1. MySQL Tutorial
2. Data Dictionary
3. INFORMATION_SCHEMA

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)