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 | ||