Updated: 2023-08-16
Data Source Initialization OLE DB Property — «numeric_i16_rules»
Name:
numeric_i16_rules
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
5.29
Rules for columns and parameters with NUMERIC/DECIMAL datatype with precisions 19..38.
The property value can be zero or the combination of the following flags:
| Value | Description |
| 1 | NUMERIC with zero scale will be processed as INT128. |
| 2 | Precision of NUMERIC will be 39 instead 38. This mode is not supported by MSSQL. |
| 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/DECIMAL (that is based on INT128) and MSSQL (linked server), add to connection string «numeric_i16_rules=4».
See also
- Initialization property numeric_i2_rules
- Initialization property numeric_i4_rules
- Initialization property numeric_i8_rules
- Initialization property int128_rules