I believe WHERE/= in MySQL is case insensitive. If you want
case-sensitive conditions, you'll want to use WHERE BINARY field LIKE
'data' or the documentation-preferred WHERE COLLATE latin1_general_cs
LIKE 'data'. Important to keep in mind if you're rolling your own
authentication.
Reference: htt
Use case insensitive field or execute query with "lowercase"
SELECT * FROM table WHERE LOWERCASE( $name ) = LOWERCASE( name )
Depends by your goal, I could let user insert space and case only for
personal informations as name, address and such, not necessary on
login, unless you need higher secur
If you were to allow spaces in the user name I would force them all to
lower case (avoid duplicates if properly spaced). However collapsing
spaces is an idea I would not even entertain to use. "John Foobar" vs.
"John Foobar" is something that is always prone to errors if a user has
to input
Hi folks,
What are your thoughts on allowing usernames with spaces, e.g. "john
smith". They're often disallowed and I was wondering on your thoughts
as to why that might be.
One reason I can think of is to avoid confusingly similar usernames,
e.g. "john smith" and "john smith" (2 spaces)
In those
