Sqlite 3.7.4 with android 2.2

Question

How to use sqlite 3.7.4 with android 2.2? Because, any queries doesn't work on android 2.2, but work honeycomb,ICS. Please help me.

This is my query:

select snippet(content,'<b>','</b>','...',-1) as mytext,docid as _id from content where text match 'book*'"


public Cursor getSearchResult(String str) {
    String query = new StringBuilder().append("select snippet(content,'<b>','</b>','...',-1) as mytext,docid as _id from content where").append(" text match '").append(str).append("*'").toString();
    return database.rawQuery(query, null);
}

I'm using fts3 table.

Log:

android.database.sqlite.SQLiteException: SQL logic error or missing database

This query work on ICS.

I read this and this post.

What do you mean by "any queries doesn't work on android 2.2"? — wtsang02, Dec 13 '12 at 01:04
A fact is that we don't know how your table looks like, how your wrote your code to use this query, so please add your code as well. — wtsang02, Dec 13 '12 at 01:10
adnroid 2.2, 2.3.2 support sqlite 3.6.22, but i want use sqlite 3.7.4 with andoid 2.2. — Sardor Dushamov, Dec 13 '12 at 01:19
What exactly doesn't work on Android 2.2? I mean, what happens when you try to run this query? — Code-Apprentice, Dec 13 '12 at 01:23

score 2 · Accepted Answer · edited May 23 '17 at 12:21

You cannot change the version of SQLite that is in the firmware of the device. It is what it is, and this SO answer has a nice roster of what it is for different versions.

You could try SQLCipher for Android, which I think is based on a newer version of SQLite than 3.7.4, and it gives you encryption if you want it. But it will add a few MB to your APK size.

Otherwise, you will need to rework your schemas and queries to something that works successfully on older SQLite versions, or stop supporting the older Android versions that have a too-old version of SQLite.

Sqlite 3.7.4 with android 2.2

1 Answers1