Forums install as latin1 not utf8
|Reported by:||DJPaul||Owned by:|
|Component:||Component - Core||Keywords:||confirmed|
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.