Perhaps, but that is only part of the story, and all of that is hidden from the user and is only relevant in terms of how the number is stored on disk. You can define a column as int, smallint, largeint, bigint, etc and, irrespective of which you use, SQLite will save the data to disk transparently using the smallest on disk format possible for the value you have saved.
For the record there is another possibility for the values 0 and 1 where SQLite uses no storage at all, other than the type byte in the serial types array. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 1 May 2018 at 17:05, Gerry Snyder <mesmerizer...@gmail.com> wrote: > From the docs: > > *INTEGER*. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 > bytes depending on the magnitude of the value. > > So perhaps you should have said " SQLite integers are all up to 64 bit." > > Gerry > > On Tue, May 1, 2018 at 8:56 AM, Paul Sanderson < > sandersonforens...@gmail.com > > wrote: > > > SQLite integers are all 64 bit - I don't about postgress, so unless > > postgress allows integers bigger than 64 bit, and you use them, you > should > > be OK with your table definitions above. > > > > Paul > > www.sandersonforensics.com > > skype: r3scue193 > > twitter: @sandersonforens > > Tel +44 (0)1326 572786 > > http://sandersonforensics.com/forum/content.php?195-SQLite- > > Forensic-Toolkit > > -Forensic Toolkit for SQLite > > email from a work address for a fully functional demo licence > > > > On 1 May 2018 at 16:29, dmp <da...@dandymadeproductions.com> wrote: > > > > > Hello, > > > > > > Given a conversion from a database table that contains BigInt, long, > > > field from PostgreSQL to a SQLite similar table. > > > > > > CREATE TABLE postgresqltypes ( > > > data_type_id serial, > > > bigInt_type bigint) > > > > > > CREATE TABLE sqlitetypes ( > > > data_type_id INTEGER PRIMARY KEY AUTOINCREMENT, > > > int_type INTEGER) > > > > > > How to store, for values outside range for Integer, > > > String or Real? > > > > > > danap. > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
