Search IN ENGLISH vodka matches documents that originally contained terms such as vodka, Vodka, VodkA, etc. Search IN RUSSUAN (and may be other langs) водка return only водка and ignore Водка, ВОДКА.... Both apps, win10 and mobile. Fix it please!
This is likely not easily fixed as SQLite searches only support case insensitive searches of ASCII characters and Russian language uses Unicode characters
How about this? https://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing http://sqlfiddle.com/#!7/ae8f8/2 I have no idea what it is, by the way! 😄
See this comment: https://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing#comment22403022_973785
Hi again! I'm pretty sure i found the solution! 2 articles : SQLite and fully working UNICODE and How to make android SQLite be good with a non-English languages
Both of it in russian, but easily translated. For example:
Probably many people know the embedded SQLite database. SQLite fully supports UTF-8 and UTF-16 encodings. But there is one caveat, for string and text fields whose characters fall outside the ASCII table, the case-insensitive LIKE and ORDER BY do not work.
I have no right to insist, I only hope for your thirst for knowledge and perfectionism in app development! : Thanks!
😄
Thanks for your efforts but I am not planning to compile SQLite myself. To workaround this issue I would rather load the whole text contents of the database into memory and then make a text search - this will be slower than the current search but work for non-ASCII langauges.
👍
Will be fixed with the next app update
