MediaWiki MySQL 数据库字符集,使用哪一种?
我正在安装 MediaWiki,但很困惑要使用哪个字符集。 我之前安装过 MediaWiki,但从未关注过这一点:我使用默认选择(二进制),并且它没有引起任何问题,但现在它不同了,我不会犯错误。
我安装的wiki主要使用Arabic,语言是阿拉伯语。
我应该使用哪个数据库字符集?
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
使用默认值
二进制
。从历史上看,当 MySQL 的 Unicode 支持严重破坏以至于破坏了非 BMP 字符。后来,utf8
作为实验被添加到 MediaWiki 中,但它导致了一些奇怪语言的损坏。不久前,MySQL 5.5 终于引入了 utf8mb4 字符集来解决这个问题,但 MW 还不支持它。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.