On 15 Dec 2018, at 9:24am, Darren Duncan <dar...@darrenduncan.net> wrote:
> If yours is a financial application then you should be using exact numeric > types only, such as integers that represent multiples of whatever quantum you > are using, such as cents; fractional numbers are a display or user input > format only, and in those cases they are character strings. This. Currency amounts should be stored as integers. The problem you spotted is just one of many bad consequences of using floating arithmetic on currencies. Please please consider changing the way your database works. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users