Oracle® Database Heterogeneous Connectivity Administrator's Guide 10g Release 1 (10.1) Part Number B10764-01 |
|
|
View PDF |
Oracle maps the ANSI datatypes through ODBC and OLE DB interfaces to supported Oracle datatypes. When the results of a query are returned, Oracle9i converts the ODBC or OLE DB datatypes to Oracle datatypes.
The tables in this appendix show how Oracle maps ANSI datatypes through ODBC and OLE DB interfaces to supported Oracle datatypes when it is retrieving data from a non-Oracle system.
This appendix contains the following tables:
Table B-1 maps ODBC datatypes into equivalent ANSI and Oracle datatypes. In some cases equivalence to ANSI datatypes is not guaranteed to be exact because the ANSI SQL standard delegates definition of numeric precision and maximum length of character data to individual implementations. This table reflects a probable mapping between ANSI and ODBC datatypes for a typical implementation of ANSI SQL.