Updated on 2025-07-22 GMT+08:00
GaussDB->Oracle
|
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
