On Fri, Mar 8, 2013 at 5:34 AM, Pavel Volkov <pavelivol...@gmail.com> wrote:
> Hello. This is new test that illustrates the problem: > SQLite only claims to convert floating binary to decimal and back again with an accuracy of 14 significant digits. Going much beyond that requires the use of infinite precision integer math, which we have chosen to omit from the SQLite library at this time. SQLite will store and retrieve floating point values with perfect accuracy. Applications that need more than 14 significant digits of accuracy in binary to decimal conversion can still use SQLite for storage. But binary to decimal conversion should be done using another library. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users