Thank you! I mayn't need the high precision like "212345678901234567890123456.988290112".
John Crenshaw-2 wrote: > >> 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 > > -- View this message in context: http://old.nabble.com/How-to-input-a-double-num--tp26105457p26127343.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users