Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ DB2 for LUW->GaussDB

Updated on 2024-11-30 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

Previous topic: GaussDB->Oracle

Next topic: DB2 for LUW->GaussDB(DWS)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.