On Thu, Sep 27, 2018 at 11:05:24AM -0600, Keith Medcalf wrote: > so the only way to store something [larger than a signed 64-bit int] > is as a double-precision float.
I'd like to point out that you could *store* it as the hex or decimal text representation of the integer. If you included leading zeros, it would even sort correctly. If you actually need to do arithmetic on it within sqlite, that's another matter. (Or any non-weird base representation, for that matter.) -- nw _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users