phpMyAdmin 哪种 UTF8 可以正确显示中文、俄语、阿拉伯语？
我需要在 MYSQL 数据库中输入 10 种语言的内容（问题是：中文、俄语、阿拉伯语），客户端应该能够通过 phpMyAdmin 以及管理区域读取和编辑它们。
我使用过 utf8-bin、utf8_unicode_ci、utf8_general_ci，但字符在 phpMyAdmin 中无法正确显示。此外，我需要考虑搜索和排序问题，并且由于我无法理解上述语言，我担心某些字符可能会被转义或错误映射。
在这种情况下哪个 UT8 最好？
phpMyAdmin显示字符为“å¸åŠª”çăçµåˆå“çªèˆ‡ç§'技”是否正常？
如何让 phpMyAdmin 以人类可读的方式显示内容？
I need to input content in 10 languages in MYSQL database (problem ones are: Chinese, Russian, Arabic) and client should be able to read and edit them through phpMyAdmin as well as admin area.
I have used utf8-bin, utf8_unicode_ci, utf8_general_ci, but the characters does not show properly in phpMyAdmin. In addition I need to consider the search and sort problems and as I can't understand the above languages I am worrying that some characters might be escaped or mapped incorrectly.
Which UT8 is the best in this case?
Is it normal for phpMyAdmin to display characters as '動力å“牌çµåˆå“牌與科技'?
How can I make phpMyAdmin display the content in human readable way?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的数据库看起来没有任何问题（除非数据库的内容也是 UTF-8 mojibake，在传输到浏览器的过程中经过双重 mojibake）；您所包含的输出示例看起来您的浏览器解释 phpMyAdmin 页面的编码不正确，很可能是某种 ISO-8859 变体。检查并确保您的浏览器编码为 UTF-8。
不同的排序规则指定不同的排序和搜索规则，但编码仍然相同。如果您要在数据库中存储多种语言，请使用
utf8_general_ci。There is nothing wrong with your database it seems (unless the database's contents is also UTF-8 mojibake, being double-mojibaked on the way to your browser); the output example you have included looks like that your browser's encoding to interpret the phpMyAdmin page in is incorrect, most likely some ISO-8859 variant. Check and make sure that your browser's encoding is UTF-8.
The different collations specify different rules for sorting and searching, but the encoding is still the same. If you are storing multiple languages in the database, use
utf8_general_ci.