sqlite typeless database cause DataType Exception

Sqlite is a type less database. There is no difference if you keep your column type VARCHAR or numeric. It can store both numeric and character value under any type.

Sqlite does not generate any error on wrong typed value assignment to column. So you need to take care about these issues at programming level, especially writing program for small devices.

You will get the error when trying to access this information. For example, I have a column "displayOrder" in my "Component" table. The column datatype is integer. if you did not assign any value in this column while inserting, then Sqlite automatically puts the NULL in that column. and when you access this from

r.getInteger(index)

where r is the row retreived from cursor, then it throws DataType exception, because sqlite treats the NULL is non integer value.