R
R
real_mista2015-07-28 15:52:41
Android
real_mista, 2015-07-28 15:52:41

Android. How to configure ormlite for like query, case insensitive for cyrillic text?

I make a selection
myDao.query(querybuilder.where().like("title", searchString + "%").prepare()); Any text in the search works correctly on English characters. But for Cyrillic, searchString must be entered case-sensitive. What needs to be done so that search results for Cyrillic are displayed case-insensitively.
The only thing I found stackoverflow.com/questions/5945222/in-ormlite-wri...
But for the Russian text the situation does not change.
I made a crutch solution by creating another column where I save only the upperCase text, and do a search on it, but IMHO this is not true.
Here's what to do? Can I make a request in some other way? Or is there some kind of database settings during the initial initialization? I will be grateful for any answers.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg Gamega, 2015-07-28
@gadfi

I will be grateful for any answers.

if it’s not critical in terms of the size of the database, leave it like that, this is an old sqlite problem and not orm

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question