Petite Abeille wrote:
> From an efficiency point of view, would one be better off storing that key as
> a blob or text? In other words, store the raw byte
> sequence directly or use a hex text representation of it?
Blob
> So, binary:
>
>hashblob not null collate binary, -- as the raw byte sequence
Collation doesn't apply to blobs - they are always compared as binary.
> Any gotchas in using blob as keys (unique or otherwise)?
None that I know of.
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users