> Does anyone knows why floating point numbers are truncated when they are > written or read from the database?!
SQLite stores real numbers as 8 byte IEEE floats, which can hold approximately 16 significant digits. See: http://www.sqlite.org/datatype3.html You could get slightly more significant digits by using scaled 64 bit integers-- approximately 18-19 decimal digits. (This comes at the expense of additional code complexity and loss of range.) If you need more than that, you'll need to store numbers as strings (or blobs), and do your own arbitrary precision math as needed. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
