Re: [sqlite] LIKE operator case-senisitive for international characters

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 ca

[sqlite] LIKE operator case-senisitive for international characters

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 form