Mapping 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 Oracle Server supports a set of data types. The ODBC Driver for Oracle maps these data types to their appropriate ODBC SQL data types. The following table lists the Oracle 7.3 Server data types and their corresponding ODBC SQL data types.
The ODBC Driver for Oracle supports Oracle 7.3 and some Oracle8 data types. For more information about supported Oracle8 data types, see Supported Data Types.
| Oracle Server data type | ODBC SQL data type |
|---|---|
| CHAR | SQL_CHAR |
| DATE | SQL_TIMESTAMP |
| FLOAT | SQL_DOUBLE |
| INTEGER | SQL_DECIMAL |
| LONG | SQL_LONGVARCHAR |
| LONG RAW | SQL_LONGVARBINARY |
| NUMBER | SQL_DECIMAL |
| RAW | SQL_VARBINARY |
| VARCHAR2 | SQL_VARCHAR |
Note
For more information about the allowable size of the VARCHAR column, see VARCHAR Column Size in this guide.