COLLATIONS

This view stores information about collations for each character set.

Column Name	Description
`COLLATION_NAME`	The collation name.
`CHARACTER_SET_NAME`	The name of the associated character set for a given collation.
`ID`	The unique `ID` for a given collation.
`IS_DEFAULT`	`YES` if given collation is a the default for its character set, otherwise blank.
`IS_COMPILED`	Whether or not the character set is fully compiled.
`SORTLEN`	The amount of memory, in bytes, required in order for strings of a given character set to be sorted.

Was this article helpful?