mORMot Open Source

CycleSoft

Member

Registered: 2013-01-18

Posts: 34

SQL DECIMAL Field type

Hi,
I have to connect to an axisting Microsoft SQL Server with several fields declared as DECIMAL(19, 5).

Currency only supports 4 decimal digits, and Double (the data type mORMot 'sees' these columns) is a floating point data type, so rounding errors could happens.

How do you suggest to handle these columns ?

Thanks!