Android: use Upper function for Unicode string


#1

Hello!
In my sqlite database I need finding record using ‘like’ syntaxes. The search must be case insensitive and work for Unicode.

When I execute query:
select 1 where Upper(‘москва’) like '%МОСКВА%'
for non encrypted sqlite database (without SQLCipher) or with version 3.4.0, I get one record.
On encrypted sqlite database with SQLCipher version 3.5.x I get zero record.

What do I need to do to, to return support ICU for encrypted database?

With respect,
Alexander


#2

Hello @alisichkin

SQLCipher for Android removed ICU support in the 3.5 series release for support on Android 7:

Adding support for ICU to the library would require a custom build and/or extension to the library.