Search code examples
androidsqlitearabicpersianselect-query

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 recognize those chars.

i insert data into database by copy them from HTML file. so when i type string and search, no result show. but if i copy string and search, it works.

The string from the HTML file is:

"احكام خمس"

The typed string is:

"احکام خمس"

Solution

  • 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).