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

Updated on 2024-11-30 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
LONG VARCHAR	TEXT	Yes
GRAPHIC	CHARACTER VARYING	Yes
VARGRAPHIC	CHARACTER VARYING	Yes
LONG VARGRAPHIC	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
BOOLEAN	BOOL	Yes
DB2SECURITYLABEL	CHARACTER VARYING(128)	Yes

Parent topic: Mapping Data Types

Previous topic: DB2 for LUW->GaussDB

Next topic: PostgreSQL->GaussDB

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.