10

I'm installing MediaWiki and am confused which charset to use. I installed MediaWiki before but never took care of this: I used the default choice (which is Binary), and it didn't cause any problem, but now it's different and I can make no mistake.

The wiki I'm installing is mainly using Arabic, the language is Arabic.

Which Database charset should I use?

Nemo
  • 2,441
  • 2
  • 29
  • 63
Tamer Shlash
  • 9,314
  • 5
  • 44
  • 82

1 Answers1

12

Use the default, binary. Historically, it was the only option when MySQL's Unicode support was so broken that it corrupted non-BMP characters. Later, utf8 was added to MediaWiki as an experiment, but it resulted in corruption for some weird languages. Not so long ago, utf8mb4 charset was finally introduced in MySQL 5.5 that fixes this problem, but it isn't supported by MW yet.

MaxSem
  • 3,457
  • 21
  • 34
  • 2
    Do you know if this is still correct after all this time (shot in the dark I know) – tim.baker Jul 13 '16 at 13:02
  • 3
    Yup, nothing changed. – MaxSem Jul 15 '16 at 00:54
  • See https://www.mediawiki.org/wiki/Manual:$wgDBTableOptions for how you can configure your MediaWiki Table Options and https://wiki.freephile.org/wiki/Collation for more info on inspecting or altering your collation and charset. – Greg Rundlett Jun 01 '18 at 05:22