Help Center/ GaussDB/ M-Compatibility Developer Guide(Distributed)/ SQL Reference/ Data Types/ Overview
Updated on 2025-10-23 GMT+08:00
View PDF
Share

Overview

M-compatible databases support the following data types:

  • Boolean type: BOOLEAN or BOOL. For details, see Boolean Types.
  • Binary types: BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB. For details, see Table 1.
  • Character types: CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. For details, see Table 1.
  • Time types: DATE, TIME, TIMESTAMP, DATETIME, and YEAR. For details, see Table 1.
  • Bit string type: BIT. For details, see Table 1.
  • Numeric types: TINYINT, SMALLINT, MEDIUMINT, INT/INTEGER, BIGINT, NUMERIC or DECIMAL, FLOAT, and DOUBLE. For details, see Numeric Types.

M-compatible databases support conversion between data types. For details, see Type Conversion.

M-compatible databases support constraints on data types. For details, see "MySQL Compatibility Description > M-compatible Mode" in Compatibility Description.

Parent topic: Data Types