On Sun, Aug 26, 2018, 2:21 AM D Burgess <dburges...@gmail.com> wrote:
> 2. Mixed 64/32 bit system that has integers that use the full 64 bits. > Numbers are sourced by realtime hardware. > Absence of 64 bit unsigned means addition of few functions to handle > inserts and display representation(s), numbers stored as text/blobs. > Again this all works, just extra code and indexes are less than > optimum (compared to previous used mysql). > But, as noted, you could just store those as blobs, bigendian if you want sorting, and indexing will work just fine. No other conversion needed. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users