On 2018-12-16 6:54 AM, Wout Mertens wrote:
I'd also like to point out a problem with integer money: inflation. For USD
it's been OK so far, but imagine having to handle the Zimbabwean Dollar,
which ended up having 100 trillion dollar notes. Good way to overflow your
integers.

With floating point, that's not a problem.

What you're talking about is NOT a problem with integer money. Integers have unlimited precision, they are as large as you need them to be, there is no such thing as overflowing them. When you're using a computer to represent the integers, you just use a data type capable of representing the largest integers you could ever possibly need to use for storage or intermediate calculations, if necessary a variable size representation such as BigInt or binary-coded-decimal. -- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to