Help Center> Data Replication Service> Service Overview> Mapping Data Types> DB2 for LUW->GaussDB
Updated on 2023-07-03 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

CHARACTER VARYING

Yes

LONGVARCHAR

TEXT

Yes

GRAPHIC

CHARACTER VARYING

Yes

VARGRAPHIC

CHARACTER VARYING

Yes

LONGVARGRAPHIC

TEXT

Yes

CLOB

CLOB

Yes

DBCLOB

TEXT

Yes

BLOB

BLOB

Yes

BINARY

BYTEA

Yes

VARBINARY

BYTEA

Yes

REAL

REAL

Yes

DOUBLE

DOUBLE PRECISION

Yes

SMALLINT

SMALLINT

Yes

INTEGER

INT

Yes

BIGINT

BIGINT

Yes

DECIMAL

NUMERIC

Yes

DECFLOAT

NUMERIC (65,10)

Yes

DATE

DATE

Yes

TIME

TIME

Yes

TIMESTAMP

TIMESTAMP(6) WITHOUT TIME ZONE

Yes

XML

TEXT

Yes (only in full mode)

BOOLEAN

BOOLEAN

Yes

DB2SECURITYLABEL

CHARACTER VARYING(128)

Yes
Parent topic: Mapping Data Types