Updated on 2025-07-22 GMT+08:00
DB2 for LUW->GaussDB
|
Data Type (DB2 for LUW) |
Data Type (GaussDB) |
Whether to Support Mapping |
|---|---|---|
|
CHARACTER |
CHARACTER |
Yes |
|
VARCHAR |
VARCHAR |
Yes |
|
LONG VARCHAR |
TEXT |
Yes |
|
GRAPHIC |
NVARCHAR2 |
Yes |
|
VARGRAPHIC |
NVARCHAR2 |
Yes |
|
LONG VARGRAPHIC |
TEXT |
Yes |
|
CLOB |
CLOB |
Yes |
|
DBCLOB |
TEXT |
Yes |
|
BLOB |
BLOB |
Yes |
|
BINARY |
RAW |
Yes |
|
VARBINARY |
RAW |
Yes |
|
REAL |
REAL |
Yes |
|
DOUBLE |
FLOAT8 |
Yes |
|
SMALLINT |
SMALLINT |
Yes |
|
INTEGER |
INTEGER |
Yes |
|
BIGINT |
BIGINT |
Yes |
|
DECIMAL |
DECIMAL |
Yes |
|
DECFLOAT |
NUMERIC |
Yes |
|
DATE |
DATE |
Yes |
|
TIME |
TIME(0) WITHOUT TIME ZONE |
Yes |
|
TIMESTAMP |
TIMESTAMP(6) WITHOUT TIME ZONE |
Yes |
|
XML |
TEXT |
Yes |
|
BOOLEAN |
BOOLEAN |
Yes |
|
DB2SECURITYLABEL |
VARCHAR (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.
