Re: [sqlite] not allowing an empty column

On Sat, 2007-02-03 at 00:53 -0600, P Kishor wrote: > how do I add a constraint to a column so neither null nor empty > strings ("") are allowed? > create table tbl(col CHECK (col IS NOT NULL AND col != '')); - To un

[sqlite] not allowing an empty column

how do I add a constraint to a column so neither null nor empty strings ("") are allowed? -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --