Supported Data Types (ODBC Driver for Oracle)

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.

The ODBC Driver for Oracle supports all Oracle 7.3 data types; however, it does not support any of the new Oracle8 data types listed here.

Data type Oracle 7.3 Oracle8
BFILE n/a Not supported
BLOB n/a Not supported
CHAR Supported Supported
CLOB n/a Not supported
DATE Supported Supported
FLOAT Supported Supported
INTEGER Supported Supported
LONG Supported Supported
LONG RAW Supported Supported
NCHAR n/a Not supported
NCLOB n/a Not supported
NUMBER Supported Supported
NVARCHAR2 n/a Not supported
RAW Supported Supported
VARCHAR2 Supported Supported
MLSLABEL Not supported. Not supported.
Note

For more information about the allowable size of the VARCHAR column, see VARCHAR Column Size in this guide.