Persian/arabic Search In Sqlite Android Gives Bad Result

i have a problem with sqlite database. it seems to not support full persian/arabic characters. when i search some fields based on persian chars, most of the times Sqlite can't reco

Solution 1:

These strings are different.

The HTML string begins with the characters U+0627, U+062D, and U+0643 (Alef, Hah, and Kaf).

The third character of the typed string is not U+0643 but U+06A9 (Keheh).

Solution 2:

Sqlite is very simple supported persian/arabic. read this link. sqlite database in persian language

Solution 3:

Try this:

select part fromtablewhere season = N'خمس';

If that not help, try using operators like and %.

I'm already using SQLite for more than 2 years in Persian supported projects in production environments and has no problem at all.

Udate:

I'm using SQLite via NHibernate. So myself never generate or write a query. To be honest never noticed how NHibernate send queries to SQLite.