How different are they? Could this be [unavoidable] binary floating point storage limitations?
Nick. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Lippautz Sent: 30 November 2009 13:50 To: [email protected] Subject: [sqlite] sqlite3 bind and insert double values Hej, I am using sqlite_bind_double on a prepared statement (C API). The insert completes, however, the value stored in the sqlite table is different from the output of a casual printf("%f",..) Am I wrong when assuming that they should be the same. (double values are gathered by a gps and are in range of %1.6f up to %3.9f Thanks in advance! _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
