SQLite Forum

Issues with sqlite3IsNaN() and HAVE_ISNAN
Double-check your results please.  You should have gotten a correct database
as in post (13), with the last four bytes in ascending order of value.

Another thing to try is to compile with -DSQLITE_DEBUG.  With that option
enabled, you should get an assertion fault if you try to read or write a
floating point value using the wrong byte order.

Based on the experience of this thread, the next release might raise
an error if you try to run sqlite3_open() using an SQLite that has been built
with the wrong SQLITE_MIXED_ENDIAN_64BIT_FLOAT setting, regardless of the