Updated on 2024-11-30 GMT+08:00

GaussDB->GaussDB(DWS)

Table 1 Data type mapping

Data Type (GaussDB)

Data Type (GaussDB(DWS))

Whether to Support Mapping

TINYINT

TINYINT

Yes

SMALLINT

SMALLINT

Yes

INT

INT

Yes

BIGINT

BIGINT

Yes

NUMERIC

NUMERIC

Yes

NUMERIC(P,S)

NUMERIC(P,S)

Yes

REAL

REAL

Yes

DOUBLE PRECISION

DOUBLE PRECISION

Yes

CHAR(N)

CHAR(N)

Yes

VARCHAR(N)

VARCHAR(N)

Yes

NVARCHAR2

NVARCHAR2

Yes

TEXT

TEXT

Yes

BOOLEAN

BOOLEAN

Yes

TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP WITHOUT TIME ZONE

Yes

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH TIME ZONE

Yes

TIME WITHOUT TIME ZONE

TIME WITHOUT TIME ZONE

Yes

TIME WITH TIME ZONE

TIME WITH TIME ZONE

Yes

CHARACTER

CHAR

Yes

CHARACTER VARYING

VARCHAR2

Yes

DATE

DATE

Yes

BIT(N)

BIT(N)

Yes (only in full mode)

BIT VARYING(N)

BIT VARYING(N)

Yes

BLOB

BLOB

Yes

RAW

RAW

Yes (only in full mode)

BYTEA

BYTEA

Yes

MONEY

MONEY

Yes (only in full mode)

TINYINT UNSIGNED

SMALLINT

Yes

SMALLINT UNSIGNED

INT

Yes

INTEGER UNSIGNED

BIGINT

Yes

BIGINT UNSIGNED

NUMERIC

Yes