Skip to main content
Skip to main content

collations

Overview​

View all collation methods for character sets. This table is only used for compatibility with MySQL behavior and holds no practical significance. It does not truly reflect the character collation methods used by Doris.

Database​

information_schema

Table Information​

Column NameTypeDescription
COLLATION_NAMEvarchar(512)The name of the character set collation method
CHARACTER_SET_NAMEvarchar(64)The name of the associated character set
IDbigintThe ID of the collation method
IS_DEFAULTvarchar(64)Indicates if it is the current default collation method.
IS_COMPILEDvarchar(64)Indicates if it is compiled into the service
SORTLENbigintRelated to the memory used by this collation algorithm