Hi Igor, thankyou. If I wish to make this modification now, what steps would I need to take? And in your opinion what % of the optimisation of doing it with integers would this provide?
Thanks, Ian On 01/02/2011 16:19, Igor Tandetnik wrote: > 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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users