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.