Help Center> Data Replication Service> Service Overview> Mapping Data Types> DB2 for LUW->GaussDB
Updated on 2024-03-28 GMT+08:00
View PDF

DB2 for LUW->GaussDB

Table 1 Data type mapping

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