Updated: 2019-02-07
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 NUMERIC-columns with precisions 5..9. Can be zero or combination of following flags:
| Value | Description |
| 1 | NUMERIC with zero scale will be DBTYPE_I4. |
| 2 | Precision of NUMERIC will be 10 instead 9. |
If you get the problems with NUMERIC and MSSQL (linked server), add to connection string «numeric_i4_rules=2».
See also
- Initialization property numeric_i2_rules
- Initialization property numeric_i8_rules