The key is to come up with a bit string encoding in bytes that is suitable for use in table keys -- they have to sort correctly when sorted lexicographically. The encoding should be reasonably efficient; one byte per-bit, for example, would be too inefficient (though in a pinch much better than no bit string support). I'm thinking of a 7 bits / byte encoding, with the remaining indicating the last byte of the encoding, which byte would contain up to 4 bits of the bit string plus 3 bits to encode the length of the bit string mod 8.
Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users