On 10-01-11 13:09, Simon Slavin wrote: > On 10 Jan 2011, at 10:05am, KimTaein wrote: > >> What is the largest number that I can store in integer data type in sqlite? >> I was not able to find it on sqlite website. > You're right. It's not in the obvious place. You can, however, find it here: > > <http://www.sqlite.org/fileformat.html#varint_format> > > If I understand it correctly, integers can take up 64 bits, so the largest > number would be about > > 1.84467441e19 > sqlite> select typeof((9223372036854775807)) ; integer sqlite> select typeof((9223372036854775808)) ; real sqlite>
so, i think, its 2^64-1 Luuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
