On Tue, Nov 30, 2010 at 12:29 AM, Shane Harrelson <sh...@sqlite.org> wrote:
> It turns out the same problem exists on Linux (I used sqlite3-3.7.3.bin); for example: sqlite> create table t1(d float); sqlite> insert into t1 values(9.87e+31); sqlite> select * from t1; 9.87000000000001e+31 So it seems that extended precision is not enough, and to fix the problem, higher precision is needed. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users