GaussDB->MySQL

Table 1 Data type mapping

Data Type (GaussDB)

Data Type (MySQL)

Whether to Support Mapping

CHARACTER

CHAR

Yes

CHARACTER VARYING

VARCHAR

Yes

BYTEA/BLOB/RAW

BINARY/VARBINARY/TINYBLOB /BLOB/MEDIUMBLOB/LONGBLOB

Yes

JSON

JSON

Yes

TEXT/CLOB

TINYTEXT/MEDIUMTEXT /LONGTEXT/ TEXT

Yes

TINYINT

SMALLINT

Yes

SMALLINT

SMALLINT

Yes

INTEGER

INT

Yes

BIGINT

BIGINT

Yes

FLOAT4

FLOAT

Yes

FLOAT8/DOUBLE PRECISION

DOUBLE

Yes

DATE

DATE

Yes

TIMESTAMP WITHOUT TIME ZONE

DATETIME

Yes

SMALLDATETIME

DATETIME

Yes

TIMESTAMP WITH TIME ZONE

TIMESTAMP

Yes

TIME WITH TIME ZONE

TIME

Yes

TIME WITHOUT TIME ZONE

TIME

Yes

BIT

BIT

Yes

MONEY

VARCHAR

Yes

BOOLEAN

BOOLEAN

Yes

NUMBER

DECIMAL

Yes

NUMBERIC

DECIMAL

Yes

DECIMAL

DECIMAL

Yes