Devart ODBC Driver for Oracle supports all Oracle data types.
The following table describes the mapping between the Oracle and ODBC data types.
| Oracle data type | ODBC data type |
|---|---|
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 |
SQL_TYPE_TIMESTAMP |
TIMESTAMP WITH TIME ZONE |
SQL_TYPE_TIMESTAMP |
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 |
SQL_VARCHAR |
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 |