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> ....
>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 mailing list

Reply via email to