Null and Empty String/Character in SQLIte Android

Question

when i execute: dbObj.execSql("INSERT INTO table_name (col1,col2) VALUES(1,\"\") "); col2 is saved as NULL? or EMPTY STRING? OR WHAT!!!!!?

Because on retrieval it shows col2 is NULL, even when my table_name deifinition is:

CREATE TABLE table_name( col1 INTEGER, col2 VARCHAR(255) NOT NULL DEFAULT \"\");

Side note: The SQL string delimeter is ', not ". sqlite is quite lenient in this regard, but using " in place of ' is explicitly deprecated. — dhke
– dhke, Commented Sep 15, 2015 at 10:43

The incredible Jan · Accepted Answer · 2019-01-11 13:46:15Z

1

No reason to scream. Your question is a little stupid. You insert an empty string. So obviously an empty string is saved.

SQLiteDatabase's method is "execSQL". "execSql" doesn't exist.

Maybe your code to read col2 is wrong...

answered Jan 11, 2019 at 13:46

90611 silver badges18 bronze badges

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

1 Answer 1