Excuse me, the test (test/atof1.test) of sqlite3 distribution, of course. It is guilty? Or tcl real to text conversation? Why only on the platform x32. Thanks.
On Fri, Mar 8, 2013 at 3:10 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov <pavelivol...@gmail.com> wrote: > >> And more tests. Perhaps one of the problems in converting real -> text? >> > > Binary to decimal conversion is *the* problem. TCL uses an infinite > precision integer math library to do exact binary to decimal conversion. > SQLite does not have access to such a library and so exact integer to > decimal conversion is beyond its reach. > > I repeat: SQLite stores and retrieves IEEE floating point values with > perfect accuracy. But it only does binary to decimal conversion of IEEE > floating point numbers with 14 or 15 digits of accuracy. If you need more > accuracy than this, use SQLite only for storage and use a different library > for your binary to decimal conversion. > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users