Updated on 2024-03-28 GMT+08:00

Oracle->GaussDB(DWS)

Table 1 Data type mapping

Data Type (Oracle)

Data Type (GaussDB(DWS))

Whether to Support Mapping

CHAR

CHAR

Yes

VARCHAR

VARCHAR

Yes

VARCHAR2

VARCHAR

Yes

NCHAR

NCHAR

Yes

NVARCHAR2

NVARCHAR

Yes

NUMBER

NUMBER

Yes

BINARY_FLOAT

REAL

Yes

BINARY_DOUBLE

DOUBLE

Yes

FLOAT

FLOAT/REAL

Yes

DATE

TIMESTAMP

Yes

TIMESTAMP

TIMESTAMP

Yes

TIMESTAMP WITH TIME ZONE

TIMESTAMPTZ

Yes

TIMESTAMP WITH LOCAL TIME ZONE

TIMESTAMPTZ

Yes

INTERVAL

INTERVAL

Yes

BLOB

BYTEA

Yes

CLOB

CLOB

Yes

NCLOB

TEXT

Yes

LONG

TEXT

Yes

LONG_RAW

BYTEA

Yes

RAW (non-primary key and non-unique key column)

BYTEA

Yes

RAW (primary key and unique key column)

VARCHAR

Yes

ROWID

CHARACTER(18)

Yes

UROWID

-

No

XMLTYPE

-

No

BFILE

-

No

SDO_GEOMETRY

-

No