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:
| Column | Description |
|---|---|
COLLATION_NAME | Collation name. |
CHARACTER_SET_NAME | Name of the associated character set. |
FULL_COLLATION_NAME | Name of the associated character set/collation combination. Added in MariaDB 10.10.1. |
ID | The unique identifier of this character set/collation combination. Added in MariaDB 10.10.1. |
IS_DEFAULT | If the collation is the default for this character set. Added in MariaDB 10.10.1. |
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 | | +--------------------+--------------------+---------------------+------+------------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
