Updated on 2023-07-03 GMT+08:00

TiDB->GaussDB(for MySQL)

Table 1 Data type mapping

Data Type (TiDB)

Data Type (GaussDB for MySQL)

Whether to Support Mapping

BIGINT

BIGINT

Yes

BINARY

BINARY

Yes

BIT

BIT

Yes

BLOB

BLOB

Yes

BOOLEAN

BOOLEAN

Yes

CHAR

CHAR

Yes

DATE

DATE

Yes

DATETIME

DATETIME

Yes

DECIMAL

DECIMAL

Yes

DOUBLE

DOUBLE

Yes

ENUM

ENUM

Yes

FLOAT

FLOAT

Yes

INT

INT

Yes

JSON

JSON

Yes

LONGBLOB

LONGBLOB

Yes

LONGTEXT

LONGTEXT

Yes

MEDIUMBLOB

MEDIUMBLOB

Yes

MEDIUMINT

MEDIUMINT

Yes

SET

SET

Yes

SMALLINT

SMALLINT

Yes

TEXT

TEXT

Yes

TIME

TIME

Yes

TIMESTAMP

TIMESTAMP

Yes

TINYBLOB

TINYBLOB

Yes

TINYINT

TINYINT

Yes

TINYTEXT

TINYTEXT

Yes

VARBINARY

VARBINARY

Yes

VARCHAR

VARCHAR

Yes

YEAR

YEAR

Yes