更新时间: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 + "%");
这是唯一有效的方法.