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 E.g. -- View this message in context: http://www.nabble.com/LIKE-operator-case-senisitive-for-international-characters-tf4059943.html#a11534367 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
