Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ TiDB->GaussDB(for MySQL)

Updated on 2022-07-19 GMT+08:00

View PDF

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

Parent topic: Mapping Data Types

Previous topic: PostgreSQL->GaussDB(DWS)

Next topic: Microsoft SQL Server->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.