On Tue, Nov 30, 2010 at 12:29 AM, Shane Harrelson <sh...@sqlite.org> wrote:

>
>


I've written two articles about this topic that summarize the problem and
how it may be fixed:
  -
http://www.exploringbinary.com/fifteen-digits-dont-round-trip-through-sqlite-reals/

       This covers the original mailing list discussion.

  -
http://www.exploringbinary.com/incorrect-decimal-to-floating-point-conversion-in-sqlite/

       This covers a new problem that I did not discuss on the mailing list:
SQLite's decimal to floating-point conversion routine is also inaccurate,
which can cause bad decimal round-trips as well.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to