Re: [sqlite] binary key, blob or text?

2011-09-30 Thread Petite Abeille
On Sep 30, 2011, at 2:34 PM, Igor Tandetnik wrote: >> Any gotchas in using blob as keys (unique or otherwise)? > > None that I know of. Thanks Igor :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listin

Re: [sqlite] binary key, blob or text?

2011-09-30 Thread Igor Tandetnik
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

[sqlite] binary key, blob or text?

2011-09-30 Thread Petite Abeille
Hello, Say one has a hash value as an indexed key for a table. >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? So, binary: hashblob not