The Information Schema COLLATIONS table contains a list of supported collations.

It contains the following columns:

ColumnDescription
COLLATION_NAMEName of the collation.
CHARACTER_SET_NAMEAssociated character set.
IDCollation id.
IS_DEFAULTWhether the collation is the character set's default.
IS_COMPILEDWhether the collation is compiled into the server.
SORTLENSort length, used for determining the memory used to sort strings in this collation.

The SHOW COLLATION statement returns the same results and both can be reduced in a similar way. For example, the following two statements return the same results:

SHOW COLLATION WHERE Charset LIKE 'utf8';

and

SELECT * FROM INFORMATION_SCHEMA.COLLATIONS WHERE CHARACTER_SET_NAME LIKE 'utf8';

See Setting Character Sets and Collations for details on specifying the character set at the server, database, table and column levels, and Supported Character Sets and Collations for a full list of supported characters sets and collations.

Comments

Comments loading...