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.