Ken <[EMAIL PROTECTED]> wrote: > DRH and Sqlite Community, > > Provide two sql functions: toupper() and tolower() that can be > applied. And always use binary comparison. > > so: > select x from where toupper(y) = 'HELLO' ; > would return 1 row... > > But here is the gotcha, more than likely applying that function > would negate the use of an index that would be on column y.
It would indeed. But more importantly, this technique only works for case comparisons. I'm looking for a general solution that will work on any collating sequence, such as comparison functions on Chinese text. Toupper() is not help there. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
