Hi there,

Currently I am using a SQLite 3.x database that stores and calculates
currency values using the column type NUMERIC (which I believe has a FLOAT

However this leads to errors in storing values values in floating point

I guess there is no planned support for direct fixed point types, so what is
the best approach?

Store the monetary values in an INTEGER column and multiply all values up by
100 to store in pence/cents?

Any advice?


View this message in context: 
Sent from the SQLite mailing list archive at Nabble.com.

To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to