Just a small clarification you probably forgot... On Mon, May 25, 2009 at 6:56 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > Since you haven't said what you're trying to do, it is difficult to > propose a workaround. If all you need is a unsigned long long, you > can either use an 8-byte BLOB (and a lot of casting) or you can just > store the value as a signed int and cast back and forth. > > BLOBs are likely the safer choice, since the sort order will be > correct.
This will be true if the BLOBs are stored as big-endian 64-bit integers, not if they are stored as little-endian (the first byte would then be the one less significant). Regards, ~Nuno Lucas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
