[sqlite] Why is empty string not equal to empty blob?

[Simon Slavin]

On 19 Mar 2015, at 3:19pm, Paul <devgs at ukr.net> wrote:

> This may cause very nasty hard-to-find bugs, since SQLite allows to store any 
> content inside BLOB field:
> 
> sqlite> create table foo(a int, b int, primary key(a, b));
> sqlite> insert into foo(a, b) VALUES(1, ''), (1, x'');
> sqlite> select *, length(b) from foo;

True, but the content which is stored is not of BLOB type unless you stored a 
BLOB.  Do

select *, typeof(b), length(b) from foo;

and you'll find that you get out what you put in.

Simon.