On 7/4/05, Ajay <[EMAIL PROTECTED]> wrote: > > Hello All, > > What is the maximum number that can be stored using INTEGER data type? My > table uses INTEGER to store primary key, I store lot of records in table. > I > suspect that primary key will run out of limit. How can I use long instead > of INTEGER?
As found at: http://www.sqlite.org/datatypes.html "INTEGER PRIMARY KEY columns must contain a 32-bit signed integer." and from: http://www.piclist.com/techref/microchip/math/32bmath-ph.htm "signed 32-bit numbers have a range of -2147483648 to +2147483647 -- kiel
