Pre-General Availability Draft: 2017-07-21
COLLATIONS table provides
information about collations for each character set.
COLLATION_NAMEis the collation name.
CHARACTER_SET_NAMEis the name of the character set with which the collation is associated.
IDis the collation ID.
IS_DEFAULTindicates whether the collation is the default for its character set.
IS_COMPILEDindicates whether the character set is compiled into the server.
SORTLENis related to the amount of memory required to sort strings expressed in the character set.
PAD_ATTRIBUTEindicates the collation pad attribute.
Collation information is also available from the
SHOW COLLATION statement. The
following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE 'wild'] SHOW COLLATION [LIKE 'wild']