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
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

Parent topic: Mapping Data Types

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.