[thelist] case sensitive?

Matt Warden mwarden at gmail.com
Fri Dec 9 18:22:21 CST 2005

On 12/9/05, Flavia Tarzwell (FayeC) <ftarzwell at fayec.com> wrote:
> Ok....having a brain melt here......
> Is there a way to define case sensitivity in code? I mean....if someone
> registers a username with capital letters (data written to an Access db
> - site hosted on a Windows server) and then tries to log in with caps
> off....they can't get in...
> I thought case sensitivity was determined by the server (UNIX being case
> sensitive and Windows not...)
> What can I do to make it so that case sensitivity isn't an issue...

We need more information.

Let's assume you are authenticating with SQL.

$sql = "select foo, bar from users where lower(username)=lower('".
$username . "')";

That's the basic idea. If you want case insensitivity, then you have
to implement it that way.

Matt Warden
Miami University
Oxford, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list