Default value string.empty in Sqlite table

Question

How can we specify empty string as default value in Sqlite table. Currently I am using Firefox extension for generating table. I tried putting '' , but not working.

Answer 1

With a DEFAULT constraint:

CREATE TABLE foo(
    ID   INTEGER PRIMARY KEY,
    Name TEXT    DEFAULT '',
    etc
);