Android Question Mysql net.sqlcipher.database.SQLiteException: near "AGAINST" Error

[Richard Goh]

Hi,

I had created table_FTS3 for my table and hit below error when run the SQL statement. Any idea or advice on this. Thanks in advance.

net.sqlcipher.database.SQLiteException: near "AGAINST": syntax error: , while compiling: SELECT code, Name FROM table_FTS WHERE MATCH (code, Name) AGAINST ('MyText' IN BOOLEAN MODE) order by code

 

[Erel]

Does it work if you use SQL instead of SQLCipher? I'm not sure that SQLCipher includes the FTS module.