COLLATIONStable 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.
Collation information is also available from the
SHOW COLLATIONstatement. The following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE '
wild'] SHOW COLLATION [LIKE '