android - Insert null in Sqlite table

Question

I am trying to figure how to insert a null value into an SQLite table in Android.

This is the table:

"create table my table (_id integer primary key autoincrement, " +
                                               "deviceAddress   text not null unique, " +
                                               "lookUpKey text , " + 
                                               "deviceName text , " +
                                               "contactName text , " +
                                               "playerName text , " +
                                               "playerPhoto blob " +
                                               ");";    

I wanted to use a simple Insert command via execSQL but since one of the values is a blob I can't do it (I think).

So, I am using a standard db.Insert command. How do I make one of the values null?

If I just skip it in the ContentValues object will it automatically put a null value in the column?

question from:https://stackoverflow.com/questions/9823514/insert-null-in-sqlite-table

Answer 1

Yes, you can skip the field in ContentValues and db.insert will set it NULL. Also you can use the other way:

ContentValues cv = new ContentValues();
cv.putNull("column1");
db.insert("table1", null, cv);

this directrly sets "column1" NULL. Also you can use this way in update statement.