On Tue, 2007-07-10 at 22:23 -0700, Sweden wrote: > I have searched many forums without success for the following question: > > Is there any possibility to use LIKE operator in a SELECT statment - > without being case sensitive AND with support for international characters? > I am using "PRAGMA case_sensitive_like=OFF;". The LIKE statement is in the > format '%what%' (*.*). This works fine for English characters but not for > Swedish. > > E.g. LIKE "%åker%' > > returns "fred åkerholm" > > but NOT "Fred Åkerholm" > > Doc says "International character sets are case sensitive in SQLite unless a > user-supplied collating sequence is used. But if you employ a user-supplied > collating sequence, the LIKE optimization describe here will never be > taken". > > Regards, > > Michael from Sweden
There is an extension bundled with SQLite sources that uses the ICU library to do this. See here: http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt&v=1.2 Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
