[buddypress-trac] [BuddyPress] #5093: Leading whitespace in display names messes with alphabetical sort

[buddypress-trac]

#5093: Leading whitespace in display names messes with alphabetical sort
--------------------------+-------------------------------------
 Reporter:  boonebgorges  |      Owner:
     Type:  enhancement   |     Status:  new
 Priority:  lowest        |  Milestone:  Future Release
Component:  Core          |    Version:
 Severity:  minor         |   Keywords:  has-patch needs-testing
--------------------------+-------------------------------------
 If a username is entered as " Boone" rather than "Boone", it'll show up
 first in the list when doing an alphabetical sort. In my experience, a
 name is typically entered with leading whitespace by accident. But it
 could also be used as a sort of hack to get your profile to the top of the
 list. We might consider trimming this whitespace, either on the way in (at
 the time of profile save), or at the time of query:

 {{{
 ORDER BY LTRIM(u.value)
 }}}

 Are there legit reasons for wanting leading whitespace? Would the latter
 query cause performance issues at scale? Needs testing.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5093>
BuddyPress <http://buddypress.org/>
BuddyPress