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.

possible duplicate of How to set default value to empty string for TEXT column? — Andrew T.
– Andrew T., Commented Sep 29, 2014 at 2:03

CL. · Accepted Answer · 2013-05-17 10:40:57Z

22

With a DEFAULT constraint:

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

answered May 17, 2013 at 10:40

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Default value string.empty in Sqlite table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related