SQLite Forum

Decimal128
Login
Certainly there is.  The machine epsilon for double precision is 2.220446049250313e-16 which is pretty damn small.  You only run out of precision when your value exceeds 10 to the 11, which leaves you with pennies and two guard digits of precision.  This is quite sufficient accuracy for all "exactly rounded" operations to 1/100th of a unit without exception, though if you are paranoid you might want to be able to maintain 3 guard digits in which case your magnitude limit is 10 to the 10.