SQLite does not have unsigned integers. All integers are 64-bit signed entities, but may be stored in shorter integers on disk if the value fits. This is an internal optimization and not visible externally.
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Luuk >Sent: Saturday, 9 June, 2018 05:04 >To: SQLite mailing list >Subject: [sqlite] ROWID.... > > >In the docs (https://www.sqlite.org/autoinc.html) it says: >In SQLite, table rows normally have a 64-bit signed integer ROWID ><https://www.sqlite.org/lang_createtable.html#rowid> .... > >Question: >Why it this a signed integer, and not an unsigned integer? > >Simply by choice? of is there something more to say about this? > > >_______________________________________________ >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