On 17 Dec 2018, at 21:50, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> Can someone explain to me why it has been defined this way? Having 1 bit sign, > 11 bit exponent, and 52 bit mantissa, I would have stored the (in the meantime > well known) number 211496.26 as 21149626E-2, i.e. I would have stored a 52 bit > integer number and appropriate exponent. This way there should be no rounding > errors and one would always have a guaranteed precision of ~15 significant > digits. Possibly: <https://en.wikipedia.org/wiki/Decimal_floating_point> -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users