Re: Case Matching
| From: | Michael J. Pawlowsky | Date: | Mon, 06 Jan 2003 19:29:08 +0000 |
| Subject: | Re: Case Matching | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-130482@lists.php.net to get a copy of this message | ||
What field type did you make the usernames?
TEXT types are case incensitives.... use VARCHAR
*********** REPLY SEPARATOR ***********
On 06/01/2003 at 2:09 PM ed@home.homes2see.com wrote:
>Not really sure if this would be a PHP or a MySQL issue. I'm using a
>database to store username for authentication purposes. Is there a way to
>make the user entry match case in the mysql database? Right now I have
>some users with all uppercase usernames that are able to login typing
>their username in all lower case letters.
>
>TIA,
>
>Ed
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
Cheers,
Mike
---------------------------------------------------------------------------------------------------------
Hlade's Law: If you have a difficult task, give it to a lazy person --
they will find an easier way to do it.