On Wed, Nov 30, 2016 at 9:46 AM, Chris Locke <chrisjlo...@gmail.com> wrote:
> I recently had this problem. Values stored as real values. Had to check > records in the database to see if any value had changed, and needed > updating. Even though all values in my code were singles, I had bad > rounding problems where (as an example) 0.1+2.2 did not equal 2.3 in the > database. Aargh. > Storing as integers is the way to go. > At present, I think that is the best way. Of course, we could argue that every RDMS "should" implement Decimal Floating Point. https://en.wikipedia.org/wiki/Decimal_floating_point > > Thanks, > Chris > -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
