Updated: 2023-08-12
Data Source Initialization OLE DB Property — «numeric_i8_rules»
Name:
numeric_i8_rules
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
3, 5
Rules for columns and parameters with NUMERIC/DECIMAL datatype and precisions 10..18.
The property value can be zero or the combination of the following flags:
| Value | Description |
| 1 | NUMERIC with zero scale will be DBTYPE_I8. |
| 2 | Precision of NUMERIC will be 19 instead 18. |
| 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_i8_rules=2» or «numeric_i8_rules=4».
See also
- Initialization property numeric_i2_rules
- Initialization property numeric_i4_rules
- Initialization property numeric_i16_rules
- Initialization property int128_rules