information_schema.columns.data_type

mysql

type: LONGTEXT NULL
8
type: VARCHAR NOT NULL
5.7

mariadb

type: NULL
Note:
The column's data type.
© 2022 MariaDB
5.1-10.8
type: VARCHAR NOT NULL
Note:
The column's data type.
© 2022 MariaDB
10.2-10.7

tidb

type: VARCHAR(64) NULL
Note:
The type of data in the column.
© 2022 PingCAP
4-6.1

postgres

type: CHARACTER_DATA NULL
Note:
Data type of the column, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in udt_name and associated columns). If the column is based on a domain, this column refers to the type underlying the domain (and the domain is identified in domain_name and associated columns).
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
Data type of the column, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in udt_name and associated columns). If the column is based on a domain, this column refers to the type underlying the domain (and the domain is identified in domain_name and associated columns).
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.6

cockroachdb

type: unknown
Note:
Data type of the column.
© 2022 CockroachDB
1-21.2

mssql

type: NVARCHAR(128) NULL
Note:
System-supplied data type.
© Microsoft 2022
aps-pdw-2016-sql-server-ver15