Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Data Types

Data Types
The following table shows how the Oracle data types are mapped to the standard ODBC data types. Unicode Support lists Oracle to Unicode data type mappings.
BINARY FLOAT#rfi1363233895036/Oracle10g
BLOB#rfi1363233895036/Oracle10g
CLOB#rfi1363233895036/Oracle10g
TIMESTAMP WITH LOCAL TIMEZONE#rfi1363233895036/oracle9, 4
TIMESTAMP WITH TIMEZONE#rfi1363233895036/oracle95

1
Read-Only

2
Supported only on Oracle 10g and higher.

3
Supported only on Oracle 9i and higher.

4
Timestamp with timezone mapping changes based on the setting of the Fetch TSWTZ as Timestamp option only on Oracle 10g R2 and higher.

5
Timestamp with timezone mapping changes based on the setting of the Fetch TSWTZ as Timestamp option only on Oracle 10g R2 and higher.

6
Supported only on Oracle 9i R2 and higher.

The Oracle Wire Protocol driver does not support any object types (also known as abstract data types). When the driver encounters an object type during data retrieval, it returns an Unknown Data Type error (SQL State HY000).
See Retrieving Data Type Information for more information about data types.
XMLType
Examples

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.