The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation.
The COLLATION_CHARACTER_SET_APPLICABILITY table has these columns:
COLLATION_NAME
The collation name.
CHARACTER_SET_NAME
The name of the character set with which the collation is associated.
The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement.