Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table
The Information Schema COLLATION_CHARACTER_SET_APPLICABILITY table maps which character sets are associated with which collations.
The Information Schema COLLATION_CHARACTER_SET_APPLICABILITY table shows which character sets are associated with which collations.
It contains the following columns:
The table is table of the base COLLATION_NAMES in the same way that 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 table with its field TABLE_COLLATIONS, this should be joined to FULL_COLLATION_NAME in the COLLATION_CHARACTER_SET_APPLICABILITY table.
See for details on specifying the character set at the server, database, table and column levels.
This page is licensed: CC BY-SA / Gnu FDL