Searching a SQLite database which contains cyrillic data

I have a problem searching my SQLite database, which contains data written with cyrillic characters. If the key word is also cyrillic, then everything is ok, but if not, th开发者_如何学运维en I can`t get the result in my Android application.

Does anyone have an idea how can I implement searching the cyrilic data no matter the charset of the keyword? Thanks

If you use UTF8 encode, There will be no problem.

Actually not. String comparison works only with ascii characters (sort, upper, lower and like). If you are using non-ascii chars you should install plugin, which is like whole SQLite in size. Proof.

If you are interested in cyrillic symbols, try this link.

If you use UTF8 encode, There will be no problem.