The COLLATIONS table provides
information about collations for each character set.
INFORMATION_SCHEMA Name | SHOW Name | Remarks |
|---|---|---|
COLLATION_NAME | Collation | |
CHARACTER_SET_NAME | Charset | MySQL extension |
ID | Id | MySQL extension |
IS_DEFAULT | Default | MySQL extension |
IS_COMPILED | Compiled | MySQL extension |
SORTLEN | Sortlen | MySQL extension |
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.
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']