尽管字符集和排序规则正确，网页仍输出问号代替 unicode 字符? [英] Webpage outputting question marks in place of unicode characters, despite character sets and collation being correct?

问题描述

当我从我的数据库中获取一条记录时，其中的数据库、表和行都设置为 utf8_unicode_ci，我收到一个用对角线方块框起来的问题，而不是正确的 unicode特点;尽管我还在页面上设置了 HTML 编码:

When I fetch a record from my database, where the database, the table, and the row are all set to utf8_unicode_ci, I recieve a question boxed in a diagonal square in place of the correct unicode character; this is despite me also setting the HTML encoding on the page with:

 <meta charset="utf8">

我有一个怀疑，但是它与 MySQL/PHP 有关，因为当我 print_r 输出时，问号仍在显示，而手动输入的度数符号(我应该看到的符号)工作良好.

I have a suspicion however it is to do with MySQL/PHP though because when I print_r the output the question marks are still displaying while a manually entered degree symbol (the symbol I should be seeing) works fine.

这个 SQL 查询也没有做任何事情:

This SQL query also did nothing:

SET NAMES utf8;

有什么想法吗?我已经检查了我设置的每一端.

Any ideas? I've checked every end of my setup.

推荐答案

utf8_unicode_ci 是排序规则，需要字符集为 utf8 为例:

utf8_unicode_ci is the collation, you need the character set as utf8 as example:

CREATE TABLE someTable DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;

正如 adrienne 在此处的回答中所述:

As adrienne states in their answer here:

确保以下所有内容均属实:

make sure that all of the following are true:

• 数据库连接使用的是 UTF-8
• 数据库表使用的是 UTF-8
• 数据库表中的各个列使用的是 UTF-8
• 数据实际上存储在数据库内的 UTF-8 编码中(如果您从错误的来源导入，通常情况并非如此，或更改表或列排序规则)
• 网页正在请求 UTF-8
• Apache 正在服务 UTF-8

• The DB connection is using UTF-8
• The DB tables are using UTF-8
• The individual columns in the DB tables are using UTF-8
• The data is actually stored properly in the UTF-8 encoding inside the database (often not the case if you've imported from bad sources, or changed table or column collations)
• The web page is requesting UTF-8
• Apache is serving UTF-8

这篇关于尽管字符集和排序规则正确，网页仍输出问号代替 unicode 字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！