Client will set column to "" even if 'Allow empty' is unchecked

[nathanlindsay]

If you uncheck 'Allow empty' for a column, the client is still able to set the value of that column to "" without throwing any errors.

Is this intended behaviour?

[steve-chavez]

Allow empty is for null columns, it doesn't prevent empty text fields. For doing this, you could add a check constraint:

alter table tbl add check (trim(col) <> '')

(Maybe the GUI can include a shortcut for the check)