I have field in the database defined as NUMBER(30,6).
If I enter 123456798, I see in Servoy 123456792 and 123456792 in Oracle! (Notice that the 98 is converted to 92).
May be it’s clearer if I write the numbers in columns:
Input: 123456789
Servoy: 123456792
Oracle: 123456792
Another examples:
Input: 1234567890
Servoy: 1234567936
Oracle: 1234567940
Input: 123456789012
Servoy: 123456790528
Oracle: 123456791000
In Servoy Developer (in the Define dataproviders dialog) I see the field defined as:
type: NUMBER
length: 6