且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Windows 商店的 Sqlite 不搜索阿拉伯语文本

更新时间:2022-06-26 06:19:00

经过多次尝试,我们得出了解决方案.显然,SQL 数据库上的 SQLlite 层仅在以如下参数化查询样式输入时才识别阿拉伯字母:

After a lot of trials, we came to the solution to this. Apparently the SQLlite layer over the SQL database only recognize Arabic letters when it's entered in a parameterized query style like this:

//define your connection here
static SQLite.SQLiteConnection dbConn = = new SQLite.SQLiteConnection(file.Path);
//in your method that makes the call:
string text="الم";
dbConn.Query<DB.QuranText>(@"SELECT * FROM QuranText where AyaWithoutTashkeel LIKE", "%" + text + "%");

这是唯一有效的方法.