The supported OpenDB data types when using an Oracle database are described below.
| Oracle Data Type | Supported by OpenDB | Comments |
|---|---|---|
| bfile | No | Uses ODBC data type sql_longvarbinary. |
| blob | No | Uses ODBC data type sql_longvarbinary. |
| char | Yes | |
| clob | Yes | |
| date | Yes | |
| float | Yes | |
| long | Yes | |
| long raw | No | Uses ODBC data type sql_longvarbinary. |
| nchar | Yes | |
| nclob | Yes | |
| number | Yes | |
| nvarchar2 | Yes | |
| raw | No | Uses ODBC data type sql_varbinary. |
| rowid | No | |
| varchar2 | Yes | |
| urowid | No |