On 2/1/2011 10:10 AM, Ian Hardingham wrote: > My core users table has a user defined by a string which is their name. > This string is used to address many other tables relating to users. Not > only is the primary key a string (which I understand is bad enough), but > I also have to use LIKE rather than = because the high level language I > use is a bit eccentric about case-ing.
You could have created your table like this: create table MyTable(username text primary key collate NOCASE, ...); Then, plain vanilla = comparison would be case-insensitive (for latin characters A-Z and a-z only, but then LIKE has the same limitation), and would use the index. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users