Hello. It seems I can't do an indexed case sensitive search on a column unless I specify COLLATE NOCASE on the column when I create the table. But if I do that, then I can't do an indexed case insensitive search (I tried appending '' to the column name, and it does a case insensitive search, but not an indexed one). It doesn't seem to matter that I've created both types of indexes for that column. Is there some way to do both types of searches on the column, if I have both types of indexes created for the column? I'd rather not have to store the column twice.
Thanks! -- View this message in context: http://www.nabble.com/Doing-NOCASE-and-BINARY-searches-on-the-same-column-tp20385264p20385264.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
