SQLite.Net.SQLiteException: unrecognized token

[xleon]

This is working:

SELECT * FROM Stock WHERE ProductName LIKE '%áa%'

This is throwing:

SELECT * FROM Stock WHERE ProductName LIKE '%aá%';

Here is the error:

[MonoDroid] UNHANDLED EXCEPTION:
[MonoDroid] SQLite.Net.SQLiteException: unrecognized token: "'%aá%"

As you can notice, there is a missing " ' " at the end of the query.
I´ve checked the query with a console trace and the last " ' " is there but it´s missing in the actual execution as you can see in the error.

[kyurkchyan]

I had similar issue, what I did I used parameters. So do something like this, the
string query = "SELECT * FROM Stock WHERE ProductName LIKE ?";
var result = connection.Query(query, "%áa%");