Oracle data type mappings
The table below shows a list of supported Oracle field data types for Microsoft OLE DB Provider for Oracle and Oracle OLE DB Provider for Oracle and how they are mapped via ActiveX Data Object (ADO) types through iBridge to Analyst’s Notebook.
Note: Oracle field data types not listed in the table are
unsupported in iBridge.
| Oracle Data Type | ADO Data Type for Microsoft OLE DB Provider for Oracle # | ADO Data Type for Oracle OLE DB Provider for Oracle # | iBridge Data Type | Analyst’s Notebook Data Type |
|---|---|---|---|---|
| DATE | adDBTimeStamp (135) | adDBTimeStamp (135) | Date | Time |
| NUMBER 1 | adNumeric (131) | adNumeric (131) | Double | Number |
| NUMBER 2 | adNumeric (131) | adNumeric (131) | Double | Number |
| NUMBER 3 | adVarNumeric (139) | adVarNumeric (139) | Double | Number |
| CHAR | adChar (129) | adChar (129) | String | Text |
| CLOB | adChar (129) | adChar (129) | Memo | Text |
| LONG | adChar (129) | adChar (129) | Memo | Text |
| VARCHAR2 | adChar (129) | adChar (129) | String | Text |
| BFILE | adBinary (128) | adBinary (128) | Binary | Binary |
| BLOB | adBinary (128) | adBinary (128) | Binary | Binary |
| LONG RAW | adBinary (128) | adBinary (128) | Binary | Binary |
| RAW | adBinary (128) | adBinary (128) | Binary | Binary |
Note:
- # - Numbers in parentheses denote the numeric value of the ADO data type enumerations.
- 1 - If the scale = 0 and the precision <> 0.
- 2 - If the scale <> 0 and the precision <> 0.
- 3 - If the scale = 0 and the precision = 0.