更新时间：2024-09-11 GMT+08:00
HTAP标准版语法说明和数据类型对应关系
GaussDB(for MySQL)实例数据同步到HTAP时会被转成对应的类型，详情请参考表1。
|
数据类型 |
GaussDB(for MySQL)数据类型 |
HTAP数据类型 |
|---|---|---|
|
NUMERTIC TYPES |
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 TYPES |
DATE |
DATE |
|
DATETIME |
DATETIME |
|
|
TIMESTAMP |
DATETIME |
|
|
TIME |
STRING |
|
|
YEAR |
INT |
|
|
String Data Types |
CHAR |
CHAR/VARCHAR |
|
VARCHAR |
VARCHAR |
|
|
BINARY |
VARBINARY |
|
|
VARBINARY |
VARBINARY |
|
|
BLOB |
VARBINARY |
|
|
TEXT |
STRING |
|
|
ENUM |
STRING |
|
|
SET |
STRING |
|
|
Spatial Data Types |
GEOMETRY |
STRING |
|
POINT |
STRING |
|
|
LINESTRING |
STRING |
|
|
POLYGON |
STRING |
|
|
MULTIPOINT |
STRING |
|
|
MULTILINESTRING |
STRING |
|
|
MULTIPOLYGON |
STRING |
|
|
GEOMETRYCOLLECTION |
STRING |
|
|
JSON Data Types |
JSON |
JSON |
