[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