在MySQL中存储乌尔都语字符 [英] Storing Urdu characters in MySQL

问题描述

我在Mysql表中存储urdu字符时遇到问题. HTML表单中的值存储在表中，但是当我在phpmyadmin中查看时，它显示了奇怪的字符.

I am having problems storing urdu characters in Mysql table. Values from HTML form are stored in tables but when I view in phpmyadmin, it shows weird characters.

我尝试了ucs2和utf8归类，但是我存储的新值仍然是未知字符.

I have tried ucs2 and utf8 collations but still new values which I store are unknown characters.

正确的归类类型是什么?还是还有其他不对的地方?

What is the correct collation type? Or is there anything else that is wrong?

谢谢

推荐答案

如果使用MySQL工作台，则尝试将列设置为utf8-utf8_general_ci.

Try setting your column as utf8-utf8_general_ci like this if you are using MySQL workbench.

然后您将能够保存urdu字符

Then you will be able to save urdu characters

出于准确性考虑，建议使用utf8_unicode_ci

Recommend using utf8_unicode_ci for accuracy

这篇关于在MySQL中存储乌尔都语字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！