information_schema.character_sets.default_collate_name

mysql

type: VARCHAR NOT NULL
5.7-8

mariadb

type: NULL
Note:
Default collation used.
© 2022 MariaDB
5.1-10.8
type: VARCHAR NOT NULL
Note:
Default collation used.
© 2022 MariaDB
10.2-10.7

tidb

type: VARCHAR(32) NULL
Note:
The default collation name of the character set.
© 2022 PingCAP
4-6.1

postgres

type: SQL_IDENTIFIER NULL
Note:
Name of the default collation. The default collation is identified as the collation that matches the COLLATE and CTYPE settings of the current database. If there is no such collation, then this column and the associated schema and catalog columns are null.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: SQL_IDENTIFIER
Note:
Name of the default collation. The default collation is identified as the collation that matches the COLLATE and CTYPE settings of the current database. If there is no such collation, then this column and the associated schema and catalog columns are null.
© 1996-2022 The PostgreSQL Global Development Group
9.1-9.6

cockroachdb

type: unknown
Note:
Always NULL (unsupported by CockroachDB).
© 2022 CockroachDB
21.1-21.2

mssql