[buddypress-trac] [BuddyPress] #1445: Forums install as latin1 not utf8

[buddypress-trac at lists.automattic.com]

#1445: Forums install as latin1 not utf8
----------------------+-----------------------------------------------------
Reporter:  DJPaul     |       Owner:     
    Type:  defect     |      Status:  new
Priority:  major      |   Milestone:  1.2
Keywords:  confirmed  |  
----------------------+-----------------------------------------------------
 Thread: http://buddypress.org/forums/topic/forums-section-displaying-like
 Tested on BP 1.1.3 and WPMU 2.8.6.

 wp_bp_ DB tables are utf8 but wp_bb_ are latin1.  This causes problems on
 non-English character sets on the forums.  See thread linked above for
 screenshots.  Looking at BP/BB code for the one-click forum install (this
 is tested only against a "new" forum install, not upgrade) it looks like
 the default ought to be UTF8.

 In my BB-config.php in the root of the site, the charset IS set to UTF but
 the DB tables still installed as latin1.  I'm not sure if this is a BP or
 BB issue; the forums component is probably the weakest area of my
 BuddyPress knowledge. I've had a look at the code and I can't see anything
 obviously wrong.

 A new issue is that I suspect the majority of installs will have this
 problem.  Converting DB types to utf8 is apparently a non-trivial task.
 There is a blog post at http://yihui.name/en/2009/05/convert-mysql-
 database-to-utf-8-in-wordpress/ (the WP Codex is a mess on this subject)
 but looking at that plugin's code, it doesn't seem to manage the existing
 database data; the WP codex suggests changing it to a binary type before
 changing the charset, then swapping it back again.

-- 
Ticket URL: <http://trac.buddypress.org/ticket/1445>
BuddyPress <http://buddypress.org/>
BuddyPress