One annoying thing about the SQLite LIKE operator is that it's case-insensitive only for 26 latin letters. It means that searching in unicode text fields is very inconvenient because you must use the exact letter case.

I'd like to share my solution to this problem. It's pure PHP and doesn't require to recompile any source code: http://blog.amartynov.ru/?p=675