PHPBuilder - Making the SQLite LIKE operator case-insensitive for Unicode strings



RSS Twitter
Tips Databases

Making the SQLite LIKE operator case-insensitive for Unicode strings

by: Alex
|
April 7, 2011

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

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Alex

Comment:



Comment:

(Maximum characters: 1200). You have characters left.