COLLATION_CHARACTER_SET_APPLICABILITY

The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation.

  1. USE INFORMATION_SCHEMA;
  3. SELECT * FROM COLLATION_CHARACTER_SET_APPLICABILITY;

The output is as follows:

  1. +----------------+--------------------+
  2. | collation_name | character_set_name |
  3. +----------------+--------------------+
  4. | utf8_bin       | utf8               |
  5. +----------------+--------------------+

The output has these columns:

  • collation_name: the collation name.
  • character_set_name: the name of the character set with which the collation is associated.