insert into YourTable (Field1, NotNullField) values ('Empty String','');
insert into YourTable (Field1, NotNullField) values ('Null Value',NULL);The first insert one will work, the second will not. An empty string is NOT considered a NULL value. An empty string is actually considered very valid data. A value of NULL means that there is no data associated to that particular field. On Wed, Jan 5, 2011 at 12:27 PM, tinauser <[email protected]> wrote: > Hi there, > I'm an inexpert user of SQLite. > I create a table with a field NOT NULL > However i succesfully insert a record with the NOT NULL field empty. > Shouldn't this be "forbidden"? > Thanks > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
