On 3/28/17, Paul <de...@ukr.net> wrote: > According to datatypes page https://sqlite.org/datatype3.html SQLite choses > width of the integer automatically. Does it mean that if I let's say want to > bind a number 5 in the query that inserts/updates rows it will be stored in > database as 1-byte integer regardless of the use of sqlite3_bind_int() > or sqlite3_bind_int64()?
Correct. > If so, is it safe to *always* > use sqlite3_bind_int64()/sqlite3_column_int64() and forget about pain int > versions? Correct. Also, always use sqlite3_malloc64() and sqlite3_realloc64() and sqlite3_column_int64(), etc. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
