Help Center> Data Replication Service> Service Overview> Mapping Data Types> DB2 for LUW->GaussDB(DWS)
Updated on 2023-07-03 GMT+08:00
View PDF

DB2 for LUW->GaussDB(DWS)

Table 1 Data type mapping

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