> ### Oracle

> The following table lists the data types that the ODBC driver supports for Oracle:

> Table B-4. Mapping Data Types for Oracle to ODBC Data Types
> Oracle 9i Data Type | Oracle10g Data Type | ODBC Data Type
> --- | --- | ---
> BFILE | BFILE | SQL_LONGVARBINARY
> | BINARY_FLOAT | SQL_REAL
> | BINARY_DOUBLE | SQL_DOUBLE
> BLOB | BLOB | SQL_LONGVARBINARY
> CHAR(size) | CHAR(size) | SQL_CHAR1 SQL_WCHAR2
> CLOB | CLOB | SQL_LONGVARCHAR3 SQL_WLONGVARCHAR2
> DATE | DATE | SQL_TYPE_TIMESTAMP
> LONG | LONG | SQL_LONGVARCHAR1 SQL_WLONGVARCHAR2
> LONG RAW | LONG RAW | SQL_LONGVARBINARY
> NCHAR(size) | NCHAR(size) | SQL_CHAR4 SQL_WCHAR5
> NCLOB | NCLOB | SQL_LONGVARCHAR4 SQL_WLONGVARCHAR5
> NUMBER | NUMBER | SQL_FLOAT
> NUMBER(p,s) | NUMBER(p,s) | SQL_DECIMAL
> NVARCHAR2(size) | NVARCHAR2(size) | SQL_VARCHAR4 SQL_WVARCHAR5
> RAW(size) | RAW(size) | SQL_VARBINARY
> ROWID | ROWID | SQL_VARCHAR
> TIMESTAMP | TIMESTAMP | SQL_TIMESTAMP6 SQL_CHAR7
> TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP WITH LOCAL TIME ZONE | SQL_TYPE_TIMESTAMP6 SQL_CHAR7
> TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE | SQL_TYPE_TIMESTAMP6, 8, 9
> TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE | SQL_CHAR7, 8
> VARCHAR2(size) |  | SQL_VARCHAR1
> VARCHAR2(size) |  | SQL_WVARCHAR2

> 1Not present when DataSourceReportChar=False, ServiceCodePage=Database and database character set is Unicode 2Only present when ServiceCodePage=Database and database character set is Unicode 3Not present when ServiceCodePage=Database and database character set is Unicode 4Not present when ServiceCodePage=Database and database character set is Unicode 5Only present when ServiceCodePage=Database and national character set is Unicode 6Only present when DataSourceFetchTimestampAsString=False 7Only present when DataSourceFetchTimestampAsString=True 8Only present when DataSourceORAMapTSWTZ=True 9The time zone value is not accessible (or can not be set). Instead, the client time zone is used either to pass to Oracle or to convert from the stored time zone value.

> ##