[sqlite] UNSIGNED BIG INT in SQLite 3.7.11.

2013-09-06 Thread Filip Curcic
Hello, I am using Android 4.2 with SQLite 3.7.11 database. I am not being able to insert UNSIGNED BIG INT data properly. It looks to me like an overflow, because when I read it out I get a negative number. That only happens on this device, I have another 2.3 Andriod device which runs older

Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11.

2013-09-06 Thread Hick Gunter
number by the SQLite shell. -Ursprüngliche Nachricht- Von: Filip Curcic [mailto:curcic.fi...@gmail.com] Gesendet: Freitag, 06. September 2013 13:21 An: sqlite-users@sqlite.org Betreff: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11. Hello, I am using Android 4.2 with SQLite 3.7.11 database. I am

Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11.

2013-09-06 Thread Richard Hipp
On Fri, Sep 6, 2013 at 10:00 AM, Hick Gunter h...@scigames.at wrote: My guess is that you have exceeded the range of a 32 bit integer (0x7FFF) which will be rendered as a negative number by the SQLite shell. The shell works just fine with 64-bit signed integers: SQLite version 3.8.0.1

Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11.

2013-09-06 Thread Hick Gunter
...@sqlite.org] Gesendet: Freitag, 06. September 2013 16:04 An: General Discussion of SQLite Database Betreff: Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11. On Fri, Sep 6, 2013 at 10:00 AM, Hick Gunter h...@scigames.at wrote: My guess is that you have exceeded the range of a 32 bit integer