Export (0) Print
Expand All

Supported Data Types (ODBC Driver for Oracle)

Important note 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 Note

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

Show:
© 2014 Microsoft