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