"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-in "nocase" collating sequence only works for US-ASCII. Register your own nocase collating sequence using sqlite3_create_collation() if you need i18n. -- D. Richard Hipp <[EMAIL PROTECTED]>