是否可以在同一个页面中显示不同编码的数据？
我这里有两张表 - 一张是 UTF 格式的，保存可以读取的阿拉伯文本。另一个具有不同的编码，但是内容是阿拉伯语，但是在数据库中显示它，因为
ÈöÓúãö Çááøåö ÇáÑøóÍúãóäö ÇáÑøóÍöíãö
我必须在同一页面上显示两个表中的数据 - 该页面是 UTF 编码的，但是我不确定是否可以这样做或如果可能的话。我该怎么办？我的数据库是mysql，我使用的是php。
是否可以将另一个表的内容的编码转换为 UTF8 顺便说一句？
I have two tables here - one is in UTF and holds Arabic text as it can be read. The other one has a different encoding however and the content is Arabic however in the database its displayed as
ÈöÓúãö Çááøåö ÇáÑøóÍúãóäö ÇáÑøóÍöíãö
I have to show data from both tables on the same page - the page is UTF encoded however I'm not sure if this can be done or if its possible. What do i do? My database is mysql and I'm using php.
Is it possible to convert the encoding of the contents of the other table into UTF8 btw?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您必须首先对所有内容使用 mb_convert_encoding()，以确保它们一开始都是 UTF-8 格式。 https://www.php.net/manual/en/ function.mb-convert-encoding.php 然后它应该显示，假设您的 HTML 字符集是 UTF-8 并且用户安装了适当的字体。
此外，几乎所有控制台和大量免费在线 SQL 命令（如 PHPMyAdmin）都不支持 UTF-8，并且打印出乱码。我还没有找到支持 UTF-8 的免费 SSH 客户端；如果是大事，就投资 SecureCRT。
编辑：
打扰一下。我根本不读阿拉伯语，但我确实恢复了阿拉伯语。请告诉我这是否是正确的文本，如果是，请接受这个答案;_)
§？？ك？ ????? ???????????????? ?????????????
我用来得到这个的代码是：
header('内容类型：text/html;charset=utf-8');
echo mb_convert_encoding('ÈöÓúãö Çááøåö ÇáÑøóÍúãóäö ÇáÑøóÍöíãö', 'utf-8', 'iso-8859-6');
我通过此页面找到了阿拉伯编码： http://a4esl.org/c/charset.html
干杯！
You have to use mb_convert_encoding() first, on everything, to make sure it's all in UTF-8 to begin with. https://www.php.net/manual/en/function.mb-convert-encoding.php Then it should display, assuming your HTML's charset is UTF-8 and the users have the appropriate fonts installed.
Also, virtually all consoles and a great many free online SQL commanders (like PHPMyAdmin) are not UTF-8 aware and print out jibberish. I have not yet found a free SSH client that supports UTF-8; if it's a big deal, invest in SecureCRT.
EDIT:
Excuse me. I don't read Arabic at all, but I did get Arabic back. please tell me if this is the correct text, and if so, accept this answer ;_)
ب?س?ك? افف?م? افر??ح?ك?ل? افر??ح?ٍك?
The code I used to get this was:
header('Content-Type: text/html;charset=utf-8');
echo mb_convert_encoding('ÈöÓúãö Çááøåö ÇáÑøóÍúãóäö ÇáÑøóÍöíãö', 'utf-8', 'iso-8859-6');
I found the Arabic encoding via this page: http://a4esl.org/c/charset.html
Cheers!