Empty string in database

Question

I have this table in my SQLDatabase:

CREATE TABLE Book(_id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT NOT NULL)

Now my problem is that with this code no exception is thrown:

ContentValues args = new ContentValues();           
args.put("Name", "");

long id = db.insertOrThrow("Book", null, args);

I want that an exception is thrown if I try to put an empty string into the Name column. In the LogCat there is no exception too. What do I have to change in the table?

Frederico Schardong · Accepted Answer · 2013-06-18 22:32:40Z

1

An empty string is different from NULL, instead of throw an exception for empty strings, do a simple test and then execute whatever you would have in your catch block.

answered Jun 18, 2013 at 22:32

Frederico Schardong

2,1947 gold badges40 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Empty string in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related