Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table

The Information Schema COLLATION_CHARACTER_SET_APPLICABILITY table shows which character sets are associated with which collations.

It contains the following columns:

The COLLATIONS table is table of the base COLLATION_NAMES in the same way that CHARACTER_SETS table is table of the base CHARACTER_SET_NAMES. The COLLATION_CHARACTER_SET_APPLICABILITY table is the mapping between collations and character sets.

When joining the information_schema.TABLES table with its field TABLE_COLLATIONS, this should be joined to FULL_COLLATION_NAME in the COLLATION_CHARACTER_SET_APPLICABILITY table.

See Setting Character Sets and Collations for details on specifying the character set at the server, database, table and column levels.

Example

SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY  WHERE CHARACTER_SET_NAME='utf32' ORDER BY IS_DEFAULT DESC, ID LIMIT 10;
+--------------------+--------------------+---------------------+------+------------+
| COLLATION_NAME     | CHARACTER_SET_NAME | FULL_COLLATION_NAME | ID   | IS_DEFAULT |
+--------------------+--------------------+---------------------+------+------------+
| uca1400_ai_ci      | utf32              | utf32_uca1400_ai_ci | 3072 | Yes        |
| utf32_general_ci   | utf32              | utf32_general_ci    |   60 |            |
| utf32_bin          | utf32              | utf32_bin           |   61 |            |
| utf32_unicode_ci   | utf32              | utf32_unicode_ci    |  160 |            |
| utf32_icelandic_ci | utf32              | utf32_icelandic_ci  |  161 |            |
| utf32_latvian_ci   | utf32              | utf32_latvian_ci    |  162 |            |
| utf32_romanian_ci  | utf32              | utf32_romanian_ci   |  163 |            |
| utf32_slovenian_ci | utf32              | utf32_slovenian_ci  |  164 |            |
| utf32_polish_ci    | utf32              | utf32_polish_ci     |  165 |            |
| utf32_estonian_ci  | utf32              | utf32_estonian_ci   |  166 |            |
+--------------------+--------------------+---------------------+------+------------+