Oracle Data Types | Client Data Types |
|---|---|
BLOB | LONG BYTE |
CHAR(n) | CHAR(n) Note: CHARACTER(n) is a synonym for CHAR(n). |
CHARZ | Not supported |
CLOB | LONG VARCHAR |
DATE | DATE |
DECIMAL | DECIMAL(p,s) |
DISPLAY | Not supported |
FLOAT(126) | FLOAT8 |
FLOAT(63) | FLOAT4 |
INTEGER | INTEGER |
NCHAR(n) | NCHAR(n) |
NCLOB | Not supported |
NUMBER(5,0) | SMALLINT |
NUMBER(9,0) | INTEGER |
NUMBER(10,0) | INTEGER4 |
NUMBER(19,0) | BIGINT |
NUMBER(19,4) This type only maps to the MONEY data type if the NUMBER(19,4) money mapping is selected. | MONEY If you select the money mapping NUMBER(19,4) for Oracle, all data declared as NUMBER(19,4) is returned as money. |
NUMBER(38) | BIGINT |
NVARCHAR2(n) | NVARCHAR(n) |
RAW | Not Supported |
ROWID | Not supported |
STRING | Not supported |
UNSIGNED | Not supported |
VARCHAR(n) | VARCHAR(n) |
VARCHAR2(n) | VARCHAR(n) |
VARNUM | Not supported |
VARRAW | Not supported |