On 27 Sep 2018, at 5:10pm, Conor Lennon <clen...@druidsoftware.com> wrote:
> It's declared as a unsigned integer There is no such thing in SQLite. SQLite has an integer type, but it is an 8-byte signed integer. <https://www.sqlite.org/datatype3.html#storage_classes_and_datatypes> If you don't need to sort on that column, just search and select, then you could store that value as TEXT or a BLOB, whichever is more convenient. If you need to sort but don't need perfect precision, you could store the value as REAL. But SQLite has no way of handing a 64-bit unsigned integer. Sorry. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users