If you are dealing with say a chinese char set then wouldn't you want to handle this at a "global" level by modifying the database characteristics, then maybe a Pragma command would be the way to go.
[EMAIL PROTECTED] wrote: Ken 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 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
