John Stanton-3 wrote: > > I implemented a decimal type in Sqlite. It uses fixed point and correct > rounding rules. To my mind it is an essential component if one is using > Sqlite for commerical purposes and must have accurate financial > information. >
And, just to be clear: when you say you "implemented a decimal type in SQLite", you mean you stored it as an INTEGER column. And that you multiplied values by 10,000 before storing them, and divided values by 10,000 before displaying them. Jon -- View this message in context: http://www.nabble.com/Currency-Issues-tp18988348p19022729.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
