On Tue, Mar 30, 2010 at 08:41:09PM -0400, Tom Holden scratched on the wall: > > ----- Original Message ----- > From: "Simon Slavin" <slav...@bigfraud.org>
> > columnName TEXT COLLATE NOCASE > > > > then all sorting and SELECT queries on it will ignore case. > > You don't even have to change the defined collation as you can impose the > NOCASE collation in the SELECT statement as: > > SELECT * from Customers WHERE LastName = 'Shaw' COLLATE NOCASE AND FirstName > = 'Gioia' COLLATE NOCASE; If either/both of these columns has/have indexes, it is best to change it in the table definition. Otherwise you also need to define it in the index definition, as well as everywhere you expect to use the index. This is all automatic if everything is built with the collation in the table definition. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
