ODBC Driver for Oracle

Supported Data Types - ODBC Driver for Oracle

Data Type Mapping

The Devart ODBC Driver for Oracle supports all Oracle data types.

The following table describes how the Oracle data types are mapped to the ODBC 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-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback