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 (6, 3) |
NUMBER (6, 3) |
- |
NUMBER (6, 0) |
NUMBER (6, 0) |
- |
NUMBER (3) |
NUMBER (3) |
- |
NUMBER (6, -2) |
NUMBER (6, -2) |
- |
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) |
- |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot