Re: [sqlite] SQLite3 support for 64-bit unsigned integers

2009-05-25 Thread Nuno Lucas
Just a small clarification you probably forgot... On Mon, May 25, 2009 at 6:56 PM, Jay A. Kreibich wrote: >  Since you haven't said what you're trying to do, it is difficult to >  propose a workaround.  If all you need is a unsigned long long, you >  can either use an 8-byte BLOB (and a lot of ca

Re: [sqlite] SQLite3 support for 64-bit unsigned integers

2009-05-25 Thread Jay A. Kreibich
On Sun, May 24, 2009 at 11:28:59PM -0700, Kelly Jones scratched on the wall: > I tried inserting 2^63-1 and the two integers after it into an SQLite3 > db, but this happened: > > SQLite version 3.6.11 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TA

Re: [sqlite] SQLite3 support for 64-bit unsigned integers

2009-05-25 Thread John Machin
On 25/05/2009 4:28 PM, Kelly Jones wrote: > I tried inserting 2^63-1 and the two integers after it into an SQLite3 > db, but this happened: > > SQLite version 3.6.11 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE test (test INT); > sqlite> INSE

[sqlite] SQLite3 support for 64-bit unsigned integers

2009-05-24 Thread Kelly Jones
I tried inserting 2^63-1 and the two integers after it into an SQLite3 db, but this happened: SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE test (test INT); sqlite> INSERT INTO test VALUES (9223372036854775807); sqlite> INSERT