case sensitive authentication
case sensitive authentication
- Started
- Last post
- 1 Response
- kinetic
im authenticating people against records in a mysql db.
i thought selects where case sensitive
SELECT * FROM tablename WHERE user_name='$Name' AND user_password='$Pass'
this works with upper and lowercase chars... how can i check for exact entries?
thanks
- kinetic0
nevermind...figured it out.
for those who are interested:
SELECT * FROM tablename WHERE BINARY user_name='$Name' AND BINARY user_password='$Pass'