[interchange-bugs] [rt.icdevgroup.org #334] username case (in)sensitivity

Peter Ajamian via RT interchange at rt.icdevgroup.org
Wed Dec 16 01:10:48 UTC 2009


<URL: http://rt.icdevgroup.org/Ticket/Display.html?id=334 >

On 16/12/09 08:34, Gert van der Spoel via RT wrote:
> It is my opinion that in the case of usernames, everything should be
case insensitive. I mean no system is really going to deal with it's
customers and say, are you LAdams, or ladams, or ladaMs. Passwords will
get a boost from case sensitivity, but not usernames, that would just be
confusing.
> 
> I'm all for eventually making all uses of username in perl modules
lowercase first. Although #3 seems just fine to me.

I think that (1) it should be a userdb option and (2) it should not rely
on the screwy behavior of one particular db to implement one way or the
other.

Also I think that we should maybe change the way that the various $db
methods work so that we know that they will be either case-sensitive or
case-insensitive (I vote for the former), though that may be breaking bc
I think it's worth it to get rid of differences that we see from
different DBs.  One way is to use the BINARY function in mysql, another
way is to change certain column defenitions to VARCHAR BINARY in order
to force data in that column to be case sensitive.


Peter






More information about the interchange-bugs mailing list