D
D
Dreddik2011-06-21 11:45:40
Android
Dreddik, 2011-06-21 11:45:40

Cyrillic in SQLite, Android?

No matter how much I search, in Android it is not possible to define custom functions for SQLite.
However, I am faced with the task of searching for a string in the database. The problem is that the LIKE comparison does not understand Cyrillic upper and lower case, UPPER and LOWER do not work for Cyrillic.
In iOs I solved it with my functions, but here I can't.
How to do case insensitive search in SQLite android?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
N
Next_Alex, 2011-06-21
@Dreddik

Well, if my sclerosis does not change me, for normal work with a language other than English, in SQLite it is necessary to fasten ICU to it.
Try to dig aside here:
http://habrahabr.ru/blogs/sql/57915/
http://stackoverflow.com/questions/3944207/unicode-support-in-android-ndk
http://www.goneeded.com /android/projects/ICUaInternationalmComponentsmformUnicodeb.html

R
Ramzeska, 2013-04-17
@Ramzeska

Went the easy way, via CursorWrapper
gist.github.com/ramzes642/5400792

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question