Baruch Burstein <[email protected]> wrote:
> When selecting real (float) values, does the sqlite return (and the shell
> display) the full precision it has by default, or does it have a higher
> precision stored in the database than it displays?
SQLite stores and returns a 64-bit IEEE floating point number - those are
accurate to about 15 decimal digits (52 bits of mantissa / log2(10)).
The shell formats them with printf("%g") - this defaults to 6 digits after the
period.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
