collation_character_set_applicability

The collation_character_set_applicability view indicates a matching relationship between character sets and collations. For details, see Table 1. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.collation_character_set_applicability columns
Name	Type	Description
COLLATION_NAME	varchar(32)	Name of the collation.
CHARACTER_SET_NAME	varchar(32)	Name of the character set with which the collation is associated.

The control behavior of the GUC parameter m_format_dev_version is forward compatible.

If the value of m_format_dev_version is set to s1, you can view the information about collation of the character sets of only the current database in the view.

m_db=# SET m_format_dev_version=s1;
SET
m_db=# SELECT * FROM information_schema.collation_character_set_applicability;
   COLLATION_NAME   | CHARACTER_SET_NAME
--------------------+--------------------
 utf8mb4_0900_ai_ci | UTF8
 utf8_bin           | UTF8
 utf8_unicode_ci    | UTF8
 utf8_general_ci    | UTF8
 utf8mb4_bin        | UTF8
 utf8mb4_unicode_ci | UTF8
 utf8mb4_general_ci | UTF8
 POSIX              | UTF8
 C                  | UTF8
 default            | UTF8
(10 rows)