Updated: 2023-08-12

Data Source Initialization OLE DB Property — «numeric_i4_rules»

Name:
numeric_i4_rules
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
3, 5

Rules for columns and parameters with NUMERIC datatype and precisions 5..9 or DECIMAL datatype and precisions 1..9.

The property value can be zero or the combination of the following flags:

Value Description
1 NUMERIC with zero scale will be DBTYPE_I4.
2 Precision of NUMERIC will be 10 instead 9.
4 Data has the type DBTYPE_WSTR. This flag was added in IBProvider v5.31.

The valid values of this property: 0, 1, 2, 3, 4, 5.

If you get the problems with NUMERIC and MSSQL (linked server), add to connection string «numeric_i4_rules=2» or «numeric_i4_rules=4».

See also

Other properties of group

Other sets of properties