On 7/10/2013 9:55 AM, Paolo Bolzoni wrote:
The subject pretty much says it all. I am curious to know what sqlite3 does when asking for the result value of a column passing a type that is too small.
Casts it down to int.
For example in my system int are 32 bits as result of a query I got a 10 billions: what happens using sqlite3_column_int to get that result?
SQLite will return 1410065408, which is 1^10 mod 2^32. Use sqlite3_column_int64 to get the unmodified value.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users