ODBC to Jet Data Type Mapping for Oracle
The following table details how the
Changes to the type mappings are shown in the table as italics.
{Notes} on the above table
- FLOAT(b) specifies a floating point number with binary precision b.
The precision can range from 1 to 126.
To convert from binary to decimal precision, multiply b by 0.30103.
- Possible loss of precision
- FLOAT specifies a floating point number with decimal precision 38, or a binary precision of 126.
- NUMBER specifies a floating point number with decimal precision = 38.
- Oracle appears to return s=0, p=0 for a calculated field
- Oracle permits a maximum precision of 38.
Precision of OpenLink C Types
The choice of
Referenced by...