sqlite android中的波斯语/阿拉伯语搜索结果不好 [英] persian/arabic search in sqlite android gives bad result

问题描述

我的 sqlite 数据库有问题.它似乎不支持完整的波斯/阿拉伯字符.当我根据波斯字符搜索某些字段时，大多数情况下 Sqlite 无法识别这些字符.

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.

我通过从 HTML 文件中复制数据来将数据插入到数据库中.所以当我输入字符串并搜索时，没有结果显示.但如果我复制字符串并搜索，它会起作用.

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.

HTML 文件中的字符串是:

The string from the HTML file is:

"احكام خمس"

"احكام خمس"

输入的字符串是:

"احکام خمس"

"احکام خمس"

推荐答案

这些字符串是不同的.

HTML 字符串以字符 U+0627、U+062D 和 U+0643(Alef、Hah 和 Kaf)开头.

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

输入字符串的第三个字符不是 U+0643 而是 U+06A9 (Keheh).

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

这篇关于sqlite android中的波斯语/阿拉伯语搜索结果不好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！