On 15 May 2014, at 12:08pm, Werner Kleiner <[email protected]> wrote:
> Simon Slavin-3 wrote >> There is no need to do anything special. f you use 'Int' in SQLite it >> will be interpreted as 'INTEGER' anyway. > > Yes, but back to my datareader problem it seems that the Datareader differs > between a column which is 'INTEGER' or 'Int'. > Especially we had a problem with a Int column and value of 13 digits > (1396856032225). The datareader reads the column as a integer 32 value and > breaks or returns wrong values. (or we do something wrong :-) ) It is incorrect to assume a SQLite INTEGER can fit in a 32-bit variable. The bug is in your datareader. The datareader is not part of SQLite so you do not have a problem with SQLite. Perhaps you could something else rather than datareader or store your numbers as text. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
