skip to main content
About the Oracle Wire Protocol Driver : Data Types
  

Try DataDirect Drivers Now

Data Types

The following table shows how the Oracle data types are mapped to the standard ODBC data types.
Table 2. Oracle Data Types
Oracle
ODBC
BFILE1
SQL_LONGVARBINARY
BINARY DOUBLE2
SQL_REAL
BINARY FLOAT3
SQL_DOUBLE
BLOB4, 5
SQL_LONGVARBINARY
CHAR
SQL_CHAR
CLOB6, 7
SQL_LONGVARCHAR
DATE
SQL_TYPE_TIMESTAMP
LONG
SQL_LONGVARCHAR
LONG RAW
SQL_LONGVARBINARY
NCHAR
SQL_WVARCHAR
NCLOB
SQL_WLONGVARCHAR
NVARCHAR2
SQL_WVARCHAR
NUMBER
SQL_DOUBLE
NUMBER (p,s)
SQL_DECIMAL
RAW
SQL_VARBINARY
TIMESTAMP8
SQL_TIMESTAMP
TIMESTAMP WITH LOCAL TIMEZONE9, 10
SQL_TIMESTAMP
TIMESTAMP WITH TIMEZONE11, 12
SQL_VARCHAR
VARCHAR2
SQL_VARCHAR
XMLType13
SQL_LONGVARCHAR
1 Read-Only

2 Supported only on Oracle 10g and higher.

3 Supported only on Oracle 10g and higher.

4 Supported only on Oracle 10g and higher.

5 Supported in basic file and SecureFiles storage.

6 Supported only on Oracle 10g and higher.

7 Supported in basic file and SecureFiles storage.

8 Supported only on Oracle 9i and higher.

9 Supported only on Oracle 9i and higher.

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

11 Supported only on Oracle 9i and higher.

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

13 XMLType columns with object relational storage are not supported.

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
* Retrieving Data Type Information