MySQL 8.3 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.