phpmyadmin和MySQL数据库的阿拉伯语和英语字符问题 [英] Arabic and english character problem with phpmyadmin and MySQL databse

问题描述

亲爱的先生，

我面临着MySQL数据库和phpMyAdmin的编码问题。

我开发了一个表单。用户可以将车牌号插入MySQL数据库。用于插入和浏览的php文件都以UTF-8格式编码。假设我想插入板号为。 1 2 3صص...
但是我插入数据库后我看到盘子没有1 23ù？ ù？ ù？ ù？在数据库中。在数据库中，plateno字段的整理是utf8_unicode_ci。

所以你能告诉我我的问题在哪里或者如何在插入时看到没有使用phpmyadmin的版块？

问候，

Faruk Chowdhury。

Dear Sir,
i am facing a encoding problem with MySQL data base and phpMyAdmin.
i developed a form . From wher user can insert the Car plate No. to the MySQL database.Both of the php file for inserting and veiwing is encoded in UTF-8 format. suppose i want to insert plate no as . 1 2 3 ص ص ص ص
but i after inserting to the database i see the plate no as 1 2 3 ù? ù? ù? ù? in the database . In Database the plateno field''s collation is utf8_unicode_ci.
so can you telll me where is my problem or how can i see the plate no using phpmyadmin as i inserted ?

Regards,
Faruk Chowdhury.

推荐答案

尊敬的先生，

i面临MySQL数据库和phpMyAdmin的编码问题。

i开发了一个表单。用户可以将车牌号插入MySQL数据库。用于插入和浏览的php文件都以UTF-8格式编码。假设我想插入板号为。 $ 2 $ $ $
但我插入数据库后，我在数据库中看到的板号为1 23ù，ù，ù，ù。在数据库中，plateno字段的整理是utf8_unicode_ci。

所以你能告诉我我的问题在哪里或者如何在插入时看到没有使用phpmyadmin的版块？

问候，

Faruk Chowdhury。

Dear Sir,
i am facing a encoding problem with MySQL data base and phpMyAdmin.
i developed a form . From wher user can insert the Car plate No. to the MySQL database.Both of the php file for inserting and veiwing is encoded in UTF-8 format. suppose i want to insert plate no as . 1 2 3 ص ص ص ص
but i after inserting to the database i see the plate no as 1 2 3 ù‚ ù‚ ù‚ ù‚ in the database . In Database the plateno field''s collation is utf8_unicode_ci.
so can you telll me where is my problem or how can i see the plate no using phpmyadmin as i inserted ?

Regards,
Faruk Chowdhury.

php.ini中的语言设置是什么，你的deafult服务器设置是什么？


你试过添加：

[php]

//页面开头

header（''Content-Type：text / html; charset = utf -8''）;

[/ php]

i以前与东欧角色有类似问题

i改变了apache，mysql的语言设置和php到utf8和问题消失了

（记住phpmyadmin必须设置为与所有这些相同的字符集，否则你会看到奇怪的结果）

basiclly你有把所有东西都设置成一个字符集


问候

jx2

让我知道

what are the language setting in php.ini and whats your deafult server settings ?

have you tried to add:
[php]
//at the begining of your page
header(''Content-Type: text/html; charset=utf-8'');
[/php]
i used to have similar problem with east european characters
i changed language settings of apache, mysql and php to utf8 and problem disapeared
(remember that phpmyadmin have to be set to the same charset as all of them if not you will see strange results)
basiclly you have to set everything to one charset

regards
jx2
let me know

亲爱的先生，

i为我的所有php文件添加了标题（''Content-Type：text / html; charset = utf-8''）;

。 httpd.conf语言AddCharset UTF-8 .utf8

已添加，我的数据库也是utf8_unicode_ci和表的字段名称也使用utf8_unicode_ci设置。仍然我面临同样的问题，就像我看到那个盘子没有4 5 6 9？ ？ ？使用phpMyadmin和view.php文件，我看到盘子没有是4 5 6？ ？ ？ 。

所以你能帮我解决这个问题吗？


先谢谢。


问候，

Faruk Chowdhury。

Dear Sir,
i added the header(''Content-Type: text/html; charset=utf-8'');
to all of my php files .in httpd.conf the language AddCharset UTF-8 .utf8
added and My Database is also utf8_unicode_ci and field name of the table is also set with utf8_unicode_ci . still i am facing the same problem like as i see that plate no as 4 5 6 9 ? ? ? using phpMyadmin and from view.php file i see that plate no is as 4 5 6 ? ? ? .
so can you help me to solve this problem?

Thanks in Advance.

Regards,
Faruk Chowdhury.

尊敬的先生，

i添加了标题（'' Content-Type：text / html; charset = utf-8''）;

到我所有的php文件。在httpd.conf语言AddCharset UTF-8 .utf8

已添加，我的数据库也是utf8_unicode_ci，表的字段名也使用utf8_unicode_ci设置。仍然我面临同样的问题，就像我看到那个盘子没有4 5 6 9？ ？ ？使用phpMyadmin和view.php文件，我看到盘子没有是4 5 6？ ？ ？ 。

所以你能帮我解决这个问题吗？


先谢谢。


问候，

Faruk Chowdhury。

Dear Sir,
i added the header(''Content-Type: text/html; charset=utf-8'');
to all of my php files .in httpd.conf the language AddCharset UTF-8 .utf8
added and My Database is also utf8_unicode_ci and field name of the table is also set with utf8_unicode_ci . still i am facing the same problem like as i see that plate no as 4 5 6 9 ? ? ? using phpMyadmin and from view.php file i see that plate no is as 4 5 6 ? ? ? .
so can you help me to solve this problem?

Thanks in Advance.

Regards,
Faruk Chowdhury.

你有没有更改phpmyadmin的字符集？尝试在您的浏览器中手动更改编码为utf8

您的浏览器是否更改编码？


i有工作

： - ）

jx2

have you change charset of phpmyadmin? try manualy change encoding in your browser to utf8
do your browser change encoding?

i HAS TO WORK
:-)
jx2

这篇关于phpmyadmin和MySQL数据库的阿拉伯语和英语字符问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！