Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ GaussDB->MySQL
Updated on 2025-12-05 GMT+08:00
View PDF
Share

GaussDB->MySQL

GaussDB B or MySQL-Compatible Mode -> 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

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

TINYINT UNSIGNED

TINYINT UNSIGNED

Yes

SMALLINT UNSIGNED

SMALLINT UNSIGNED

Yes

INTEGER UNSIGNED

INTEGER UNSIGNED

Yes

BIGINT UNSIGNED

BIGINT UNSIGNED

Yes

GaussDB M-Compatible Mode -> MySQL

Table 2 Data type mapping

Data Type (GaussDB)

Data Type (MySQL)

Whether to Support Mapping

BOOL

BOOL

Yes

BOOLEAN

BOOLEAN

Yes

TINYINT

TINYINT

Yes

SMALLINT

SMALLINT

Yes

MEDIUMINT

MEDIUMINT

Yes

INT

INT

Yes

INTEGER

INTEGER

Yes

BIGINT

BIGINT

Yes

TINYINT UNSIGNED

TINYINT UNSIGNED

Yes

SMALLINT UNSIGNED

SMALLINT UNSIGNED

Yes

MEDIUMINT UNSIGNED

MEDIUMINT UNSIGNED

Yes

INTEGER UNSIGNED

INTEGER UNSIGNED

Yes

BIGINT UNSIGNED

BIGINT UNSIGNED

Yes

DECIMAL

DECIMAL

Yes

NUMERIC

DECIMAL

Yes

DEC

DECIMAL

Yes

FIXED

DECIMAL

Yes

FLOAT

FLOAT

Yes

DOUBLE

DOUBLE

Yes

DOUBLE PRECISION

DOUBLE

Yes

REAL

DOUBLE

Yes

DATE

DATE

Yes

DATETIME

DATETIME

Yes

TIMESTAMP

TIMESTAMP

Yes

TIME

TIME

Yes

YEAR

YEAR

Yes

CHAR

VARCHAR

Yes

VARCHAR

VARCHAR/ENUM/SET

Yes

TINYTEXT

TINYTEXT

Yes

TEXT

TEXT/JSON

Yes

MEDIUMTEXT

MEDIUMTEXT

Yes

LONGTEXT

LONGTEXT

Yes

BINARY

BINARY

Yes

VARBINARY

VARBINARY

Yes

TINYBLOB

TINYBLOB

Yes

BLOB

BLOB

Yes

MEDIUMBLOB

MEDIUMBLOB

Yes

LONGBLOB

LONGBLOB

Yes

BIT

BIT

Yes

JSON

JSON

Yes
Parent topic: Mapping Data Types