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

From Oracle to GaussDB

Source Data Type

Converted Data Type

Conversion Configuration

CHAR

CHAR

Mismatch character set

If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent.

VARCHAR

VARCHAR

Mismatch character set

If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent.

VARCHAR2

VARCHAR2

Mismatch character set

If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent.

NCHAR

NCHAR

Mismatch character set

If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent.

NVARCHAR2

NVARCHAR2

-

NUMBER

NUMBER

Number data type with zero scale

If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent.

NUMBER (6,3)

NUMBER (6, 3)

Number data type with zero scale

If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent.

NUMBER (6,0)

NUMBER (6,0)

Number data type with zero scale

If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent.

NUMBER (3)

NUMBER (3)

Number data type with zero scale

If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent.

NUMBER (6,-2)

NUMBER (6,-2)

Number data type with zero scale

If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent.

BINARY_FLOAT

REAL

-

BINARY_DOUBLE

BINARY_DOUBLE

-

FLOAT

DOUBLE PRECISION

Float datatype

If you select The FLOAT/FLOAT(n) will be converted to DOUBLE PRECISION, the storage of characters converted by DRS and UGO is equivalent.

INT

NUMBER(38)

Integer datatype

If you select This config will convert INT, INTEGER, and SMALLINT to NUMBER(38), , the storage of characters converted by DRS and UGO is equivalent.

INTEGER

NUMBER(38)

Integer datatype

If you select This config will convert INT, INTEGER, and SMALLINT to NUMBER(38), , the storage of characters converted by DRS and UGO is equivalent.

DATE

DATE

-

TIMESTAMP

TIMESTAMP(6)

-

TIMESTAMP_TZ

TIMESTAMP(6) WITH TIME ZONE

-

TIMESTAMP_LTZ

TIMESTAMP(6) WITH TIME ZONE

-

INTERVAL_YM

INTERVAL YEAR TO MONTH

-

INTERVAL_DS

INTERVAL DAY TO SECOND

-

BLOB

BLOB

-

CLOB

CLOB

-

NCLOB

TEXT

NCLOB datatype

If you select The NCLOB will be converted into TEXT datatype, the storage of characters converted by DRS and UGO is equivalent.

LONG

TEXT

LONG data type

If you select The LONG type will be converted into TEXT data type, the storage of characters converted by DRS and UGO is equivalent.

LONG_RAW

BYTEA

LONG RAW data type

If you select The LONG RAW will be converted into BYTEA data type, the storage of characters converted by DRS and UGO is equivalent.

RAW

RAW

-

RowID

CHAR(18)

-

NUMBER(*, 0)

NUMBER(38,0)

-

For details about the configuration items, see Editing the Configurations During Migration from Oracle to GaussDB.