search

oysteinkrog / SQLite.Net-PCL

Simple, powerful, cross-platform SQLite client and ORM - Updated version with PCL support
MIT License
353 stars 162 forks source link

Like queries with unicode tokens does not return matching results #307

Open SajithDulanjaya opened 8 years ago

SajithDulanjaya commented 8 years ago

"public List Query(string query, params object[] args)" method does not return matching objects when a query is passed with a 'LIKE' clause with a token of Unicode characters in WinRT 8.1 app. Eg: SELECT * FROM Item WHERE ItemType IN (4,3) And SearchText Like '%本%' And IsReady = 1 And FilesAvailable = 1;

This query returns expected results when queried directly from sqlite db3 file using SQLite Studio like tools.

I think this is the same issue mentioned here https://github.com/praeclarum/sqlite-net/issues/226

Luke47 commented 8 years ago

I have the same issue. How did you solve it @SajithDulanjaya ?