-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A good rule of thumb is that if you claim a bug in another component you are almost certainly wrong.
On 08/03/12 11:48, Marc L. Allen wrote: > Is that expected? To me, '' is different than NULL. They are indeed different. > Is there a way to store an empty string? Yes, store an empty string. sqlite> create table a(a text); sqlite> insert into a select ''; sqlite> insert into a select null; sqlite> select * from a; sqlite> select typeof(a) from a; text null sqlite> select 'X' || a || 'Y' from a; XY sqlite> Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9ZDqoACgkQmOOfHg372QSsAgCgjkuP3HrMs1eQA9IznpTEMYpw KTsAoMsDH9DONdp0eJJn82TWW5ZtQeT1 =nrBP -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users