Sqlite3 diacritic insensitive search iphone

Question

I've a db that contains some accent characters and i've to do an accent insensitive search as fast as possible. I tried two solutions:

• query all possible accent combination. For example: perche perchè perché pèrche pérche pèrchè pèrché pérchè pérché

• rewrite LIKE operator where i first replace all accent characters with their respective normal and then do a comparison as usual.

The first one is obviously too expensive but the second one isn't good enough.

Is there a solution i'm missing?

Thanks Marco

Answer 1

Some ather approaches. All depends of what you can do on your database.

• remove all accents from your database at insertion time or in some pre-treatment request.
• define an sqlite operator that remove accent from field before comparizon.