On Mar 8, 2012, at 1:48 PM, 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? >
works for me punkish@mumbai ~$sqlite3 SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t (a TEXT NOT NULL); sqlite> INSERT INTO t SELECT ''; sqlite> SELECT * FROM t; sqlite> SELECT Count(*) FROM t; 1 sqlite> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
