 <p>SQLite uses a more general dynamic type system. Please look at the storage classes that must have each value stored in a SQLite database: <a href="https://www.sqlite.org/lang.html" rel="nofollow">https://www.sqlite.org/lang.html</a> 1. onCreate</p> <blockquote> <p>"CREATE TABLE" + SENSORS_TABLE_NAME + "(" + SENSORS_COLUMN_ID + "INTEGER PRIMARY KEY AUTO INCREMENT," +</p> </blockquote> <p>look at: creat table --> column-def --> column-constraint AUTOINCREMENT is only one key-word</p> <blockquote> <p>SENSORS_COLUMN_NAME + "STRING" + SENSORS_COLUMN_1 + "STRING," +</p> </blockquote> <p><a href="https://www.sqlite.org/datatype3.html" rel="nofollow">https://www.sqlite.org/datatype3.html</a> There is no datatype STRING and also not, if you look at the affinity name examples. Take TEXT, or, if you wan't to give the length, VARCHAR(length)</p> <blockquote> <p>SENSORS_COLUMN_2 + "FLOAT," + SENSORS_COLUMN_3 + "FLOAT," + SENSORS_COLUMN_4 + "FLOAT," +</p> </blockquote> <p>"FLOAT" is all right and it converted into "REAL"</p> <blockquote> <p>SENSORS_COLUMN_STATUS + "BOOLEAN)"</p> </blockquote> <p>SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).(1.1 Boolean Datatype) I think, your statement may be:</p> <pre><code>db.execSQL("CREATE TABLE" + SENSORS_TABLE_NAME + "(" + SENSORS_COLUMN_ID + "INTEGER PRIMARY KEY AUTOINCREMENT," + SENSORS_COLUMN_NAME + "TEXT" + SENSORS_COLUMN_1 + "TEXT," + SENSORS_COLUMN_2 + "FLOAT," + SENSORS_COLUMN_3 + "FLOAT," + SENSORS_COLUMN_4 + "FLOAT," + SENSORS_COLUMN_STATUS + "INTEGER )" ); </code></pre> <ol start="2"> <li><p>"setVersion" and "setLocale" in onCreate I do not know if that's necessary. In the constructor you have giver the version 1: super(context, DATABASE_NAME, null, 1); Please look at reference/android/database/sqlite/SQLiteOpenHelper Better is to take a string for the version, becourse an upgrate was taken when you have a new version. </p> <p>public static final int DB_VERSION = 1;</p></li> </ol> <p>And than:</p> <pre><code>super(context, DATABASE_NAME, null, DB_VERSION); </code></pre>