How do I find the length (size) of a binary blob in sqlite

Question

I have an sqlite table that contains a BLOB file, but need to do a size/length check on the blob, how do I do that?

According to some documentation I did find, using length(blob) won't work, because length() only works on texts and will stop counting after the first NULL. My empirical tests have shown this to be true.

I'm using SQLite 3.4.2

Answer 1

haven't had this problem, but you could try length(hex(glob))/2

Answer 2

for me length(blob) works just fine, gives the same results like the other.