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 Name	Type	Description
COLLATION_NAME	varchar(512)	The name of the character set collation method
CHARACTER_SET_NAME	varchar(64)	The name of the associated character set
ID	bigint	The ID of the collation method
IS_DEFAULT	varchar(64)	Indicates if it is the current default collation method.
IS_COMPILED	varchar(64)	Indicates if it is compiled into the service
SORTLEN	bigint	Related to the memory used by this collation algorithm