2016-08-21 12:11 GMT+02:00 Richard Hipp <d...@sqlite.org>: > On 8/21/16, Cecil Westerhof <cldwester...@gmail.com> wrote: > > I have a field subject that I do not want to be empty. That means it > should > > not be NULL and it should not contain ''. At the moment I do it like > this: > > subject TEXT NOT NULL subject <> ''), > > subject TEXT NOT NULL CHECK(subject <> '') >
​Something went wrong when writing the message: that is exactly what I use. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users