Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

--- Alexander Mardirossian <[EMAIL PROTECTED]> wrote: > Thank you Daniel, > > That will help. > > Do you know if it is planned that the lookup tables > are planned to be added > any soon to the source at least as an option to have > the sqlite compiled > with them. > > BTW are you aware if there

Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

- From: "Daniel K" <[EMAIL PROTECTED]> To: "Alexander Mardirossian" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 17, 2004 11:06 AM Subject: Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3 > SQLite's understanding of upp

Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

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 pl

[sqlite] case (in)sensitiveness in LIKE operator v2 and 3

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 gi