SQLite Forum

"Office Space"... I'm losing all those pennies
An IEEE double on a computer than performs IEEE compliant arithmetic can handle numbers with an absolute dollars and cents value up to about 9,999,999,999.99 with no loss of precision (that is one penny shy of 10 american billions or 10 thousand millions for every one else) -- with 2.5 guard digits -- scale appropriately for your guard requirements.