Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ GaussDB->Oracle
Updated on 2024-11-30 GMT+08:00
View PDF
Share

GaussDB->Oracle

Table 1 Data type mapping

Data Type (GaussDB)

Data Type (Oracle)

Whether to Support Mapping

TINYINT

NUMBER

Yes

SMALLINT

NUMBER

Yes

INTEGER

NUMBER

Yes

BIGINT

NUMBER

Yes

NUMBER

NUMBER

Yes

NUMERIC

NUMBER

Yes

REAL

BINARY_FLOAT

Yes

DOUBLE PRECISION

BINARY_DOUBLE

Yes

DATE

DATE

Yes

BOOLEAN

CHAR(1)

Yes

CHARACTER

CHAR

Yes

CHARACTER VARYING

VARCHAR2

Yes

NVARCHAR2

NVARCHAR2

Yes

TEXT

CLOB

Yes

BLOB

BLOB

Yes

BYTEA

BLOB

Yes

TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP

Yes

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH TIME ZONE

Yes

TIME WITHOUT TIME ZONE

VARCHAR2(32)

Yes

TIME WITH TIME ZONE

VARCHAR2(32)

Yes

CLOB

CLOB

Yes

RAW

RAW

Yes

MONEY

VARCHAR2

Yes

TINYINT UNSIGNED

NUMBER

Yes

SMALLINT UNSIGNED

NUMBER

Yes

INTEGER UNSIGNED

NUMBER

Yes

BIGINT UNSIGNED

NUMBER

Yes
Parent topic: Mapping Data Types