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