Where do you see NULL? I see empty string. SQLite version 3.7.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table a (t text); sqlite> insert into a select ''; sqlite> .nullvalue NULL sqlite> select * from a;
sqlite> Pavel On Thu, Mar 8, 2012 at 2:48 PM, Marc L. Allen <mlal...@outsitenetworks.com> 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? > > Marc > > -- > ****************************************************************** > * * * > * Marc L. Allen * "... so many things are * > * * possible just as long as you * > * Outsite Networks, Inc. * don't know they're impossible." * > * (757) 853-3000 #215 * * > * * * > * mlal...@outsitenetworks.com * -- The Phantom Tollbooth * > * * * > ****************************************************************** > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users