iAnywhere Solutions ODBC Drivers
iAnywhere Solutions ODBC Driver for Oracle
The following table shows how the Oracle data types are mapped to the standard ODBC data types.
| Oracle | ODBC |
|---|---|
| Bfile | SQL_LONGVARBINARY1, 2 |
| BLOB | SQL_LONGVARBINARY2 |
| Char | SQL_CHAR |
| CLOB | SQL_LONGVARCHAR2 |
| Date | SQL_TYPE_TIMESTAMP |
| Long | SQL_LONGVARCHAR |
| Long Raw | SQL_LONGVARBINARY |
| Number | SQL_DOUBLE |
| Number(p,s) | SQL_DECIMAL |
| Raw | SQL_VARBINARY |
| Varchar1 | SQL_VARCHAR |
1 Valid when connecting to Oracle 8 servers; these data types support output parameters to stored procedures.
The Oracle Wire Protocol driver does not support any Abstract Data Types. When the driver encounters an Abstract Data Type during data retrieval, it will return an Unknown Data Type error (SQL State HY000).