Forum Discussion

david_creech's avatar
david_creech
Ideator I
5 years ago

Decimal data type doesn't support double precision numbers

I need to store both large and small numbers in a property of type Decimal. I set the Precision to the maximum of 38 and set the scale to 19. I expected that I could store numbers with 38 digits and ...
Properties
david_creech's avatar
david_creech
Ideator I
5 years ago

Update: Changing the value directly in SQL server works as it should. The column is set up properly with Precision 38 and Scale 19, and I can store values with 19 digits before the decimal and 19 digits after. However Aras gives a Conversion Overflow error in search grids and the item's edit form. With 10 or less digits before the decimal there is no conversion overvlow error, but the values are still truncated and padded with zeros. 

Can anyone confirm if you see the same behavior in SP9 or later versions?