Determines how the driver maps fields defined as NUMBER in Salesforce. The Salesforce API uses DOUBLE values to transfer data to and from NUMBER fields, which can cause problems when the precision of the NUMBER field is greater than the precision of a DOUBLE value. Rounding can occur when converting large values to and from DOUBLE. The NumberFieldMapping option allows you to map the NUMBER fields to the required SQL types based on their precision.
Valid Values
1 | 2 | 3
Behavior
If set to 1, the driver maps NUMBER fields with a precision of 9 or less and a scale of 0 to the INTEGER SQL type and maps all other NUMBER fields to the DOUBLE SQL type.
If set to 2, the driver maps all NUMBER fields to the DOUBLE SQL type regardless of their precision.
If set to 3, the driver maps all NUMBER fields to the DECIMAL SQL type. It can be used when the precision of the NUMBER field is greater than the precision of a DOUBLE value.
The value for this option is specified as a key=value pair in the Config Options field. See "Config Options" for details.
Default
1
GUI Tab
The value for config options are specified in the Config Options field on the Advanced tab.
