MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
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.