Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ GaussDB->MySQL

Updated on 2024-11-30 GMT+08:00

View PDF

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

Previous topic: GaussDB(for MySQL)->CSS/ES

Next topic: GaussDB->GaussDB(DWS)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.