On 3/23/2011 1:46 PM, TR Shaw wrote: > On Mar 23, 2011, at 1:25 PM, Igor Tandetnik wrote: >> Billing/accounting is best done in integers - say, in millionths of a >> dollar. > > Current US national debt is 16 digits.
A 64-bit unsigned integer can represent about $18 trillion, in millionths of a dollar. This should have both range and accuracy to spare, for most applications, but you can always trade one for the other (e.g. use units of 1/1000 of a dollar instead, for a 100 times greater range). -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users