I'm willing to bet that the problem is in your C# code. The variable receiving the INTEGER column is probably declared as an INT instead of LONG or ULONG.
-Bill > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Werner Kleiner > Sent: Thursday, May 15, 2014 7:08 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite Datareader problems with Int? > > 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 :-) ) > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/SQLite-Datareader-problems-with- > Int-tp75670p75684.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 CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
