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 is already someone working on this? Regards ----- Original Message ----- 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 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/ > >
