The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table The  COLLATIONS  table provides information about collations for each character set. The  COLLATIONS  table has these columns: The collation name. The name of the character set with which the collation is associated. The collation ID. Whether the collation is the default for its character set. Whether the character set is compiled into the server. This is related to the amount of memory required to sort strings expressed in the character set. The collation pad attribute, either  NO PAD  or  PAD SPACE . This attribute affects whether trailing spaces are significant in string comparisons; see Trailing Space Handling in Comparisons. Collation information is also available from the  SHOW COLLATION  statement. See Section 13.7.7.4, “SHOW COLLATION Statement” . The following statements are equivalent: The  COLLATION_CHARACTER_SET_APPLICABILITY  table indicates what character set is applicable for what collation. The  COLLATION_CHARACTER_SET_APPLICABILITY  table has these columns: The collation name. The name of the character set with which the collation is associated. 4781 • CHARACTER_SET_NAME • COLLATION_NAME • PAD_ATTRIBUTE • SORTLEN • IS_COMPILED • IS_DEFAULT • ID • CHARACTER_SET_NAME • COLLATION_NAME Notes 26.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE ’ wild ’] SHOW COLLATION [LIKE ’ wild ’]