Help Center/ TaurusDB/ User Guide/ HTAP Analysis (Standard Edition)/ Syntax and Data Type Mappings between HTAP and GaussDB(for MySQL) Instances

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

View PDF

Syntax and Data Type Mappings between HTAP and GaussDB(for MySQL) Instances

When data of GaussDB(for MySQL) instances is synchronized to HTAP instances, the data types will be converted. For details, see Table 1.

**Table 1** Data type conversion
Data Type	GaussDB(for MySQL) Data Type	HTAP Data Type
NUMERTIC	TINYINT	TINYINT
	TINYINT UNSIGNED	SMALLINT
	SMALLINT	SMALLINT
	SMALLINT UNSIGNED	INT
	MEDIUMINT	INT
	INTEGER/INT	INT
	INTEGER/INT UNSIGNED	BIGINT
	BIGINT	BIGINT
	BIGINT UNSIGNED	LARGEINT
	DECIMAL/NEMERIC	DECIMAL
	FLOAT	FLOAT
	DOUBLE/REAL	DOUBLE
	BIT	STRING
DATE TIME	DATE	DATE
	DATETIME	DATETIME
	TIMESTAMP	DATETIME
	TIME	STRING
	YEAR	INT
STRING	CHAR	CHAR/VARCHAR
	VARCHAR	VARCHAR
	BINARY	VARBINARY
	VARBINARY	VARBINARY
	BLOB	VARBINARY
	TEXT	STRING
	ENUM	STRING
	SET	STRING
SPATIAL	GEOMETRY	STRING
	POINT	STRING
	LINESTRING	STRING
	POLYGON	STRING
	MULTIPOINT	STRING
	MULTILINESTRING	STRING
	MULTIPOLYGON	STRING
	GEOMETRYCOLLECTION	STRING
JSON	JSON	JSON

Parent Topic: HTAP Analysis (Standard Edition)

Previous topic: Standard HTAP Account Management

Next topic: RegionlessDB Clusters

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.