subject:"\[sqlite\] case insensitive index"

Re: [sqlite] case insensitive index

2006-03-18 Thread drh

"Cory Nelson" <[EMAIL PROTECTED]> wrote: > Is this possible? I want to index a column so doing col = 'cAt' will > match with 'cat'. > Add "COLLATE nocase" to the end of the column definition in the CREATE TABLE statement and all indices will do this automatically. Note, however, that the built-

[sqlite] case insensitive index

2006-03-18 Thread Cory Nelson

Is this possible? I want to index a column so doing col = 'cAt' will match with 'cat'. -- Cory Nelson http://www.int64.org