ICU extension

[DmitriyD]

Hi everybody,

I am developing an application for android using SQL Cipher.

I`ve faced with the problem that LIKE is case sensitive when searching in Russian language.

While googling I found that I can use "ICU" extension for SQLite.

Is it possible to use it in SQL Cipher? And what steps do I need for that? I am developing on Windows OS.

Thank you in advance.

[Nick Parker]

Hi DmitriyD,

SQLCipher for Android depends on localization data from the ICU project as well. You can infact custom the dat file that is used. The ICU project provides a ICU data library customizer here:

http://apps.icu-project.org/datacustom/ICUData46.html

Nick Parker

[DmitriyD]

Hi Nick,

I include full (with data for all languages) icudt46l.zip file to assets of my project. The problem still exists.

In the project I have not-encripted database which is created on PC. I extract it from assets and export it to database created with SQLCipher. I use sqlcipher_export function.

Maybe this is the reason why LIKE works bad, is it?

Maybe database should be utf-16? 

SQL table:

CREATE TABLE if not exists ActionType (_id INTEGER PRIMARY KEY ASC AUTOINCREMENT,  Title TEXT);

SQL query: 

"select _id, Title from ActionType where title like '%" + title + "%' COLLATE LOCALIZED  "

четверг, 4 октября 2012 г., 0:00:05 UTC+4 пользователь Nick Parker написал:

[Nick Parker]

Hi DmitriyD,

Could you share the exception and error message you receive when you
execute that statement?

--

Nick Parker

[Brendan Duddridge]

Speaking of ICU, does anyone here know how to compile SQLCipher for iOS including ICU?

Thanks,

Brendan

[Billy Gray]

Hi Brendan, 

I haven't tried it, but a cursory search does show some information out there on building what's called the SQLite ICU Extension. The basic directions are for building a shared library that you then `.load` after :

http://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt

If you want a static library (e.g. libicuuc.a) for the ICUC extension, so you can include it in an iOS app, it looks like there's more work involved. There's lots of search results that turn up, but I couldn't tell you what's authoritative. This is a bit hard to follow, but might be helpful, haven't verified any of it:

http://stackoverflow.com/questions/8126233/how-to-build-icu-so-i-can-use-it-in-an-iphone-app

Best of luck,

Billy

--
Team Zetetic
http://zetetic.net