"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]>

Reply via email to