更新时间:2023-11-13 GMT+08:00
数据类型对应关系
GaussDB(for MySQL)实例数据同步到HTAP时会被转成对应的类型,详情请参考表1。
数据类型 |
GaussDB(for MySQL)数据类型 |
HTAP数据类型 |
NUMERTIC TYPES |
TINYINT |
Int8 |
SMALLINT |
Int16 |
|
MEDIUMINT |
Int32 |
|
INTEGER/INT |
Int32 |
|
BIGINT |
Int64 |
|
DECIMAL/NEMERIC |
Decimal |
|
FLOAT |
Float32 |
|
DOUBLE |
Float64 |
|
BIT |
UInt64 |
|
DATE TIME TYPES |
DATE |
Date |
DATETIME |
DateTime |
|
TIMESTAMP |
DateTime |
|
TIME |
String |
|
YEAR |
UInt16 |
|
String Data Types |
CHAR |
String |
VARCHAR |
String |
|
BINARY |
FixedString |
|
VARBINARY |
String |
|
BLOB |
String |
|
TEXT |
String |
|
ENUM |
Enum |
|
SET |
SET索引 |
|
Spatial Data Types |
GEOMETRY |
String |
POINT |
String |
|
LINESTRING |
String |
|
POLYGON |
String |
|
MULTIPOINT |
String |
|
MULTILINESTRING |
String |
|
MULTIPOLYGON |
String |
|
GEOMETRYCOLLECTION |
String |
|
JSON Data Types |
JSON |
String |
父主题: 开发指南