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.

Last modified: August 29, 2022

Was this article helpful?