ODBC Driver for Oracle

Supported Data Types

ODBC Driver for Oracle supports all the Oracle data types.

The complete list of Oracle data types is available in the Oracle documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to Oracle data types.

Oracle Data Types ODBC Data Types

CHAR

SQL_CHAR

VARCHAR2

SQL_VARCHAR

NCHAR

SQL_WCHAR

NVARCHAR2

SQL_WVARCHAR

NUMBER

SQL_NUMERIC

BINARY_FLOAT

SQL_FLOAT

BINARY_DOUBLE

SQL_REAL

DOUBLE PRECISION

SQL_DOUBLE

DATE

TIMESTAMP

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH LOCAL TIME ZONE

SQL_TYPE_TIMESTAMP

BLOB

SQL_LONGVARBINARY

CLOB

SQL_LONGVARCHAR

NCLOB

SQL_WLONGVARCHAR

BFILE

SQL_LONGVARBINARY

LONG

SQL_LONGVARCHAR

RAW

SQL_VARBINARY

LONG RAW

SQL_LONGVARBINARY

ROWID

UROWID

SQL_VARCHAR

INTERVAL YEAR TO MONTH

SQL_INTERVAL_YEAR_TO_MONTH

INTERVAL DAY TO SECOND

SQL_INTERVAL_DAY_TO_SECOND

XML

SQL_LONGVARCHAR

else

SQL_UNKNOWN_TYPE

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback