I’ve been following this conversation, quite interesting. But, and this is just a question for the conversation. Is there any reason when the user registers that the user name (email address) isn’t folded into lowercase and stored that way?
I might be missing something very obvious (as is usually the case). Ted > On Feb 25, 2016, at 6:45 PM, Paul Hoadley <[email protected] > <mailto:[email protected]>> wrote: > > On 25 Feb 2016, at 10:43 am, Paul Hoadley <[email protected] > <mailto:[email protected]>> wrote: > >> Can anyone suggest a better way? What I really need is a >> CaseInsensitiveEquals qualifier, like Java’s equalsIgnoreCase(). Is there >> such a thing? Would it be easily implemented? > > Thanks for all the replies on this thread—much appreciated. The summary seems > to be: > > 1. You can do this at the EOF level, perhaps with some minor gymnastics, and > it might be inefficient. > 2. You should probably do this at the database level, probably by using a > collation on the column. > > We’re using PostgreSQL (via Amazon RDS). Research is suggesting that > PostgreSQL isn’t going to make this easy via a collation on a column, though > there is the CITEXT type. > > http://www.postgresql.org/docs/current/static/citext.html > <http://www.postgresql.org/docs/current/static/citext.html> > > I think that’s where I’ll head. Has anyone used it? > > > -- > Paul Hoadley > http://logicsquad.net/ <http://logicsquad.net/> > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected] > <mailto:[email protected]>) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > <https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com> > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
