SQLite's understanding of upper/lower case characters
only extends to the 26 that feature in English. This
is to avoid including the huge lookup tables required
to provide case insensitive matches across the whole
range of unicode characters.
You can write a user-function that will be called in
place of the LIKE operator to get around this.
Register
the function as "like" using the
sqlite3_create_function() API and it is invoked by the
SQLite core to evaluate the LIKE operator. See the
likeFunc() function in func.c for an example.
Dan.
--- Alexander Mardirossian <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> I am using SQLite with cyrillic letters (e.g.
> russian) in the DB.
> I need to perform searches (LIKE operator)
> I want to have case-INsensitve search in the LIKE
> operator.
>
> I think this is not the case now due to the bug in
> the LIKE...but I couldn't
> find any info on the subject?
>
> Can anyone give me directions on how to handle the
> subject?
>
> Thanks.
>
> Sincerely,
> Alexander
>
>
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
