On 2 Sep 2013, at 8:25am, Eduardo Morras <emorr...@yahoo.es> wrote: > Or create the index with collate > > CREATE INDEX idx_collated_column ON myTable ( column COLLATE NOCASE )
The problem with doing it in the index is that it's hard to predict when SQLite will use a particular index. Better to think about the nature of your data when you create the table. On the other hand if you have already created your table and have lots of foreign keys it can be a pain to try to reconstruct your data by DROPping and recreating tables. It may be easier just to add a new index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users