On 08-03-2012 20:48, Marc L. Allen wrote: > Is that expected? To me, '' is different than NULL. > > create table a > ( > a text > ); > > insert into a select ''; > select * from a; > > Is there a way to store an empty string? >
insert into a values(null); .nullvalue NULL select * from a; a|length(a) |0 NULL|NULL _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
