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

Reply via email to