[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
http://mattwarden.com


This email proudly and graciously contributes to entropy.



More information about the thelist mailing list