[Bb-trac] Re: [bbPress] #1109: WP login case sensitive, BP login case insensitive

[bbPress]

#1109: WP login case sensitive, BP login case insensitive
-------------------------+--------------------------------------------------
 Reporter:  timskii      |        Owner:          
     Type:  enhancement  |       Status:  closed  
 Priority:  normal       |    Milestone:          
Component:  integration  |      Version:  1.0-rc-1
 Severity:  normal       |   Resolution:  wontfix 
 Keywords:               |  
-------------------------+--------------------------------------------------
Changes (by sambauers):

  * status:  new => closed
  * resolution:  => wontfix

Comment:

 In both WordPress and bbPress this is currently entirely dependent on the
 MySQL collation used.

 Binary collation types force case sensitivity on SELECT statements (e.g.
 utf8_bin)

 The simplest way to force this is to run this query on your MySQL table
 (only tested on bbPress 1.0)...

 {{{
 ALTER TABLE  `bb_users` CHANGE  `user_login`  `user_login` VARCHAR( 60 )
 CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
 }}}

 A similar query can be used on WordPress user tables.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/1109#comment:1>
bbPress <http://bbpress.org/>
Innovative forum development