On Jan 23, 2005, at 1:02 PM, D. Richard Hipp wrote:
Use sqlite3_create_collation() to register a collating sequence that ignores case in UTF-8 characters. Then put "COLLATE <name>" after the declaration of the column you want to be caseless.
Thanks. This works for me in English, at least:
sqlite> create table a(b text COLLATE nocase);
sqlite> insert into a values ('this');
sqlite> insert into a values ('This');
sqlite> insert into a values ('THIS');
sqlite> select * from a where b = 'this';
this
This
THIS
sqlite>Has anyone created a case-insensitive UTF-8 collation that's more correct than the "NOCASE" testing collation?
Many thanks,
David
