NYCPHP Meetup

[federico ulfo]

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 security.

My 2 morning cents :)

Sent from my iPhone

On Aug 1, 2011, at 8:43 AM, Anthony Wlodarski
<anthony at tinkertownlabs.com> wrote:

> 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 their name into a text field.  You could also break the input elements into a first name and last name fields.  When you go to display that information then you can properly insert the spaces.
>
> On 07/30/2011 06:48 PM, Mutaz Musa wrote:
>> 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 cases wouldn't collapsing multiple spaces into a single space
>> be a more conservative solution than disallowing the character
>> entirely?
>>
>> Mutaz
>> _______________________________________________
>> New York PHP Users Group Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> http://www.nyphp.org/Show-Participation
>
> --
> Anthony Wlodarski
> Lead Software Engineer
> Get2Know.me (http://www.get2know.me)
> Office: 646-285-0500 x217
> Fax: 646-285-0400
>
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation