ǥ 214 lists the data type mapping that is performed
when the source data type is an Oracle data type.
ǥ 214. Data type mapping from Oracle source data types
| Oracle 8.1.7source data type | DB2 mirror data type | DB2 Everyplace device data type | Cloudscape device data type |
|---|---|---|---|
| BFILE | unsupported | unsupported | unsupported |
| BLOB | unsupported | unsupported | unsupported |
| CHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| CLOB | unsupported | unsupported | unsupported |
| DATE | TIMESTAMP | TIMESTAMP | unsupported |
| FLOAT | unsupported | unsupported | unsupported |
| LONG | unsupported | unsupported | unsupported |
| LONG RAW | unsupported | unsupported | unsupported |
| NCHAR(n) | unsupported | unsupported | unsupported |
| NCLOB | unsupported | unsupported | unsupported |
| NUMBER(p,s) | DECIMAL | DECIMAL | DECIMAL |
| NVARCHAR2(n) | unsupported | unsupported | unsupported |
| RAW(n) | VARCHAR BIT FOR DATA | BLOB | BIT VARYING |
| REAL | unsupported | unsupported | unsupported |
| ROWID | unsupported | unsupported | unsupported |
| UROWID | unsupported | unsupported | unsupported |
| VARCHAR2(n) | VARCHAR | VARCHAR | VARCHAR |
| TIMESTAMP | TIMESTAMP | TIMESTAMP | TIMESTAMP |