MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
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_NAMEThe collation name.
CHARACTER_SET_NAMEThe name of the character set with which the collation is associated.
Notes
The
COLLATION_CHARACTER_SET_APPLICABILITY
columns are equivalent to the first two columns displayed by the
SHOW COLLATION statement.