On 14 Jun 2012, at 9:30pm, Etienne <ejlist-sql...@yahoo.fr> wrote:
> js>var db = new SQLite();
> js>db.exec("select 99990.1", function(r){writeln(r)});
> 99990.1=99990.1000000001
> true
There's no way to store the fraction 0.1 as a binary value. Read this:
<http://revjim.net/2003/05/07/funny-math/>
or go read any beginner's book on computer science. SQLite, just like every
other programming language, goes some way to fake its results but you can
usually find some very simple operation which will make it expose the fact that
it's all faked. This isn't a bug in SQLite, it's a problem with pretending you
can do the same things with binary and decimal numbers.
If you know you're going to need to store fractional values exactly, multiply
all your numbers up until you can store integers. For instance, if you need to
store integer amounts of money precisely, multiply all the values by 100, store
cents instead of Euros, and store them as INTEGER rather than REAL/FLOAT.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
