|
Supported Data Types - ODBC Driver for Oracle |
|
|
|
Supported Data Types - ODBC Driver for Oracle |
|
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 |