更新时间：2025-11-15 GMT+08:00
openGauss To GaussDB 数据类型转换
| 源数据库数据类型 | 转换后数据类型 | 相关的转换配置 |
|---|---|---|
| SMALLINT | SMALLINT | - |
| INTEGER | INTEGER | - |
| BIGINT | BIGINT | - |
| INTEGER | INTEGER | - |
| REAL | REAL | - |
| DOUBLE PRECISION | DOUBLE PRECISION | - |
| NUMERIC | NUMERIC | - |
| CHARACTER VARYING | CHARACTER VARYING | 字符数据类型转换 选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。 |
| CHARACTER | CHARACTER | 字符数据类型转换 选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。 |
| BIT | BIT | - |
| BIT VARYING | BIT VARYING | - |
| BOOLEAN | BOOLEAN | - |
| BYTEA | BYTEA | - |
| TEXT | TEXT | - |
| TIME WITHOUT TIME ZONE | TIME WITHOUT TIME ZONE | - |
| TIME WITH TIME ZONE | TIME WITH TIME ZONE | - |
| TIMESTAMP WITHOUT TIME ZONE | TIMESTAMP WITHOUT TIME ZONE | - |
| TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE | - |
| INTERVAL | INTERVAL | - |
| CIDR | CIDR | - |
| PATH | PATH | - |
| BOX | BOX | - |
| LSEG | LSEG | - |
| MACADDR | MACADDR | - |
| POINT | POINT | - |
| POLYGON | POLYGON | - |
| INET | INET | - |
| TSQUERY | TSQUERY | - |
| TSVECTOR | TSVECTOR | - |
| UUID | UUID | - |
| JSON | JSON | - |
| JSONB | JSONB | - |
父主题： 数据类型转换
