Help Center/
Data Replication Service/
Service Overview/
Mapping Data Types/
DB2 for LUW->GaussDB(DWS)
Updated on 2023-07-03 GMT+08:00
DB2 for LUW->GaussDB(DWS)
|
Data Type (DB2 for LUW) |
Data Type (GaussDB(DWS)) |
Whether to Support Mapping |
|---|---|---|
|
CHARACTER |
CHARACTER VARYING |
Yes |
|
VARCHAR |
CHARACTER VARYING |
Yes |
|
LONGVARCHAR |
TEXT |
Yes |
|
GRAPHIC |
CHARACTER VARYING |
Yes |
|
VARGRAPHIC |
CHARACTER VARYING |
Yes |
|
LONGVARGRAPHIC |
TEXT |
Yes |
|
CLOB |
TEXT |
Yes |
|
DBCLOB |
TEXT |
Yes |
|
BLOB |
BYTEA |
Yes |
|
BINARY |
BYTEA |
Yes |
|
VARBINARY |
BYTEA |
Yes |
|
REAL |
FLOAT4 |
Yes |
|
DOUBLE |
DOUBLE PRECISION |
Yes |
|
SMALLINT |
INT2 |
Yes |
|
INTEGER |
INT4 |
Yes |
|
BIGINT |
INT8 |
Yes |
|
DECIMAL |
NUMERIC |
Yes |
|
DECFLOAT |
NUMERIC (65,10) |
Yes |
|
DATE |
TIMESTAMP |
Yes |
|
TIME |
TIME |
Yes |
|
TIMESTAMP |
TIMESTAMP(6) WITHOUT TIME ZONE |
Yes |
|
XML |
TEXT |
Yes (only in full mode) |
|
BOOLEAN |
BOOL |
Yes |
|
DB2SECURITYLABEL |
CHARACTER VARYING(128) |
Yes |
Parent topic: Mapping Data Types
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
