Thanks Simon I'm yet to get to setting up a new table with COLLATE NOCASE columns and copy the old table's data into it.
On Sun, Nov 3, 2013 at 11:01 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Nov 2013, at 3:24am, SongbookDB <shaun_thom...@songbookdb.com> wrote: > > > WHERE Language !="" COLLATE NOCASE > > ORDER BY Language COLLATE NOCASE) > > By the way, if every time you refer to your Language column you want it > colated NOCASE, it's far more efficient to do it when you define the column > in the table. > > CREATE TABLE ... (..., Language TEXT COLLATE NOCASE, ...) > > Then all collations of that column are handled NOCASE and you don't have > to keep specifying it in your code or even indexes. Note that this does > not change the actual values which are stored in the table: you still get > back out the exact form of text you put in. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Shaun Thomson Owner - SongbookDB _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
