开发者

Which UTF8 - phpMyAdmin display Chinese, Russian, Arabic correctly?

开发者 https://www.devze.com 2023-03-24 06:37 出处:网络
I need to input content in 10 languagesin 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 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?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消