i need to make the username case sensitive for a login script thing.
i have it so a html form sends to a mysql query. oddly the password field works as case sensitive but the username part dosnt.
case sensitive username
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
- shiznatix
- DevNet Master
- Posts: 2745
- Joined: Tue Dec 28, 2004 5:57 pm
- Location: Tallinn, Estonia
- Contact:
it was text or what not in the mysqldatabase but i figured out a way around it so its alrite. but to change the topic of this post
when you upload a file if there is a ' character in the file name it turns that into a \ mark thus messing up everything. is there a way around this or even a way to just turn the ' into a blank space instead of a \ mark?
when you upload a file if there is a ' character in the file name it turns that into a \ mark thus messing up everything. is there a way around this or even a way to just turn the ' into a blank space instead of a \ mark?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
from the mysql manual (text type is case insensitive)
[php_man]mysql_escape[/php_man]
[php_man]mysql_real_escape[/php_man]
if you are using mysql you also might want to have a look atBLOB columns are treated as binary strings, whereas TEXT columns are treated according to their character set. For BLOB columns, sorting and comparison is case sensitive. For TEXT columns, values are sorted and compared based on the collation of the character set assigned to the column as of MySQL 4.1. Before 4.1, TEXT sorting and comparison are based on the collation of the server character set
[php_man]mysql_escape[/php_man]
[php_man]mysql_real_escape[/php_man]