information_schema.collations.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
collations | ||||||||
character_set_name | VARCHAR NOT NULL: 5.7-8 | VARCHAR NOT NULL: NULL: | VARCHAR(32) NULL: | unsupported | unsupported | unsupported | ||
collation_catalog | unsupported | unsupported | unsupported | SQL_IDENTIFIER: SQL_IDENTIFIER NULL: | unsupported | |||
collation_name | VARCHAR NOT NULL: 5.7-8 | VARCHAR NOT NULL: NULL: | VARCHAR(32) NULL: | SQL_IDENTIFIER: SQL_IDENTIFIER NULL: | unsupported | |||
collation_schema | unsupported | unsupported | unsupported | SQL_IDENTIFIER: SQL_IDENTIFIER NULL: | unsupported | |||
id | BIGINT NOT NULL: 5.7-8 | BIGINT NOT NULL: NULL: | BIGINT(11) NULL: | unsupported | unsupported | unsupported | ||
is_compiled | VARCHAR NOT NULL: 5.7-8 | VARCHAR NOT NULL: NULL: | VARCHAR(3) NULL: | unsupported | unsupported | unsupported | ||
is_default | VARCHAR NOT NULL: 5.7-8 | VARCHAR NOT NULL: NULL: | VARCHAR(3) NULL: | unsupported | unsupported | unsupported | ||
pad_attribute | ENUM NOT NULL: 8 | unsupported | unsupported | CHARACTER_DATA: CHARACTER_DATA NULL: | unsupported | |||
sortlen | BIGINT NOT NULL: 5.7-8 | BIGINT NOT NULL: NULL: | BIGINT(3) NULL: | unsupported | unsupported | unsupported | ||