Raymond Wan wrote:
Platonides wrote:
MediaWiki offers you three character sets for
MySQL:
* MySQL 4.1/5.0 binary
* MySQL 4.1/5.0 UTF-8
* MySQL 4.0 backwards-compatible UTF-8
...
Thank you for your explanation! I think I understand the differences between the 3
options. Also,
looking at the installation instructions, it seems I was asked that before and probably
just clicked
"OK". I installed Mediawiki 3-4 years ago and have been upgrading since...so
maybe back then I
wasn't asked? I honestly don't remember...
Is there a way to find out what it is set at? Since I've forced mysql to use UTF-8,
I'm not sure if
I've made a mistake...but since it's retrieving Japanese characters fine, it must
be ok... I'm just
concerned that I've broken something that will show up later on...
Thanks a lot!
Ray
Look at your table definitions. If the CREATE TABLE contains DEFAULT
CHARSET=binary or DEFAULT CHARSET=utf8, you are using the first two, and
$wgDBmysql5 should be set. Else you are using the third one and
$wgDBmysql5 should be false.
The three options are supported, if it works, don't fix it :)