On 11 Sep 2012, at 12:18pm, Baruch Burstein <bmburst...@gmail.com> 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? If the value is stored as float in the database then it is stored as a Big-endian IEEE 754-2008 64-bit floating point number: <http://www.sqlite.org/fileformat.html> The SQLite3 API allows you to request a returned value as a float and if you do so it returns 'double' as whatever your compiler thinks 'double' means. If you call "double sqlite3_column_double()", and 'double' in your compiler can contain a 64-bit floating point number, it should return the stored value exactly. Making sure you didn't accidentally store the number as text, or ask for it back as characters is your problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
