MySQL Information Schema  /  The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

Chapter 12 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. The SHOW Name values in the following table correspond to column names of the SHOW COLLATION statement.

INFORMATION_SCHEMA Name SHOW Name
COLLATION_NAME Collation
CHARACTER_SET_NAME Charset

The COLLATION_CHARACTER_SET_APPLICABILITY table has these columns:

  • COLLATION_NAME

    The collation name.

  • CHARACTER_SET_NAME

    The name of the character set with which the collation is associated.

The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.