> May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the > problem.
That won't fix it. Your number is too large to fit in any native data type. Even the plain math inside your own program won't work right, because the precision of the number is limited at the C level, not the SQLite or printf level. You'll need an arbitrary precision math library, sqlite3_bind_blob(), and sqlite3_prepare_v2(). You can't use sqlite3_bind_double() because your number is too big for a double. FYI, those arbitrary precision libraries are brutes, so brace yourself. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
