A Data Type Conversion
Oracle maps ODBC data types to supported Oracle data types. When the results of a query are returned, Oracle converts the ODBC data types to Oracle data types.
The Oracle Database Gateway for ODBC maps the data types used in ODBC-compliant data sources to supported Oracle data types. When the results of a query are returned, the Oracle database converts the ODBC data types to Oracle data types. For example, the ODBC data type SQL_TYPE_TIMESTAMP
is converted to Oracle's DATE
data type.
If a table contains a column whose data type is not supported by Oracle Database Gateway for ODBC, the column information is not returned to the Oracle database.
Table A-1 maps ODBC data types into Oracle data types.
Table A-1 Data Type Mapping and Restrictions
ODBC | Oracle | Criteria | If Oracle uses large varchar (32k) |
---|---|---|---|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
Note: It is possible under some circumstance for the |
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
Note: If an ANSI SQL implementation defines a large value for the maximum length of |
|
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
|
|
|
|
- |
|
|
|
- |
|
|
|
if Oracle DB Character Set = Unicode. Otherwise, it is not supported |
|
|
|
- |