blocks|key|3079681|text|尝试查询|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3079682|SET+NAMES+utf8|code-block|syntax|javascript|3079683|在应用程序中的任何查询之前|3079684|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

try query

<pre><code>SET NAMES utf8
</code></pre>

before any query in your application

blocks|key|326299|text|在我的服务器上，将这些添加到我的php文件中没有任何效果：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326300|ini_set('default_charset','utf-8');
mysql_set_charset('utf8');
header('Content-type:+text/html;+charset=utf-8');|code-block|syntax|javascript|326301|但是当我把这段代码添加到我的php文件的顶部时，一切都运行得很好：|326302|$mysqli->query("SET+NAMES+'utf8'");|326303|注意:我在数据库中使用了编码utf8_general_ci，但是utf8_unicode_ci对我也是一样的。|offset|length|style|CODE|326304|希望这能有所帮助。|326305|entityMap^0|0|0|0|0|E|F|W|F|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]|$M|11|N|12|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

On my server, adding these to my php file had no effect:

<pre><code>ini_set('default_charset','utf-8');
mysql_set_charset('utf8');
header('Content-type: text/html; charset=utf-8');
</code></pre>

But everything worked perfectly once I added this to the top of my php file:

<pre><code>$mysqli-&gt;query("SET NAMES 'utf8'");
</code></pre>

Note: I am using encoding <code>utf8_general_ci</code> in my database, but <code>utf8_unicode_ci</code> works the same for me.

Hope that helps.

blocks|key|328621|text|尝试将MySQL连接设置为UTF-8：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328622|SET+NAMES+'utf8'|code-block|syntax|javascript|328623|并发送显式的UTF-8标头，以防您的服务器有其他默认设置：|328624|header('Content-type:+text/html;+charset=utf-8');|328625|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Try setting the MySQL connection to UTF-8:

<pre><code>SET NAMES 'utf8'
</code></pre>

And send explicit UTF-8 headers, just in case your server has some other default settings:

<pre><code>header('Content-type: text/html; charset=utf-8');
</code></pre>

blocks|key|3079705|text|您不必将PHP和HTML文件设置为utf-8。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3079706|您只需将输出编码设置为UTF-8，浏览器就会相应地显示出来。|3079707|在HTML中：|3079708|<meta+http-equiv="Content-Type"+content="text/html;+charset=UTF-8"+/>|code-block|syntax|javascript|3079709|在PHP中：|3079710|header('Content-Type:+text/html;+charset=UTF-8');|3079711|当您从MySQL表中获得一个UTF-8的字符串时，除非您转换编码，否则它将一直是UTF-8到浏览器输出。这是浏览器解释它的方式。|3079712|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You don't have to set your PHP and HTML files to utf-8.

You just have to set your output encoding to UTF-8 and the browser will display appropriately.

In HTML:

<pre><code>&lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /&gt;
</code></pre>

In PHP:

<pre><code>header('Content-Type: text/html; charset=UTF-8');
</code></pre>

When you get a string that is UTF-8 from the MySQL table, it will be UTF-8 all the way to browser output unless you convert the encoding. It's the way that the browser inteprets it.

blocks|key|3079758|text|将内容为:+AddDefaultCharset+UTF-8的.htaccess文件放入网站根目录|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3079759|和|3079760|在连接到db之后，在dbconfig集中：|3079761|Mysql_query(“设置名称'utf8'")；|3079762|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Put .htaccess file in your web-site root with content:
AddDefaultCharset UTF-8

and

in your dbconfig set after connection to db: 

mysql_query("SET NAMES 'utf8'");

blocks|key|325556|text|这里有一个解决方案。将标题设置为header+('Content-type:+text/html;+charset=utf-8');，然后使用utf8_decode($content)打印您的内容。您必须拥有这两个才能使其正常工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|325557|entityMap^0|G|1E|1Z|L|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Here is a fix. Set the header to <code>header ('Content-type: text/html; charset=utf-8');</code> Then print your content using <code>utf8_decode($content)</code>. You must have the two to make it work.

blocks|key|3079845|text|当您在网站上显示UTF8字符，但告诉浏览器将其解释为Latin1+(或Latin2)时，您会看到这种胡言乱语：ÃƒÂŸ|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3079846|当您在网站上显示Latin1+(或Latin2)字符，但告诉浏览器将其解释为UTF8时，您会看到问号。|3079847|所以我的猜测是，您将所有内容都转换为UTF8+(我的意思是，您告诉数据库引擎、web服务器和浏览器您将使用UTF8)，但实际上您并没有将字符串转换为UTF8。|3079848|照@Darkerstar说的做。将您的转储文件转换为UTF8格式(Notepad%2B%2B可以轻松完成)，然后再次导入。|3079849|entityMap^0|1J|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|S|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|M|$]]

When you show UTF8 characters on a website but tell the browser to interpret them as Latin1 (or Latin2) you see this kind of gibberish: <code>ÃƒÂŸ</code>

When you show Latin1 (or Latin2) characters on a website, but tell the browser to interpret them as UTF8, you see question marks.

So my guess is that you switched everything to UTF8 (I mean, you told the DB Engine, the web server and the browser you would be using UTF8), but you didn't actually convert the strings to UTF8.

Do what @Darkerstar said. Convert your dump to UTF8 (Notepad++ can do that easily) and import it again.

blocks|key|3293258|text|mysql_query("SET+NAMES+UTF8");|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3293259|在我的"connection.php“末尾添加这一行就解决了我的问题。|unstyled|3293260|我的连接文件的完整代码是：|3293261|<?php
#+FileName="Connection_php_mysql.htm"
#+Type="MYSQL"
#+HTTP="true"
$hostname_test+=+"localhost";
$database_test+=+"test";
$username_test+=+"username";
$password_test+=+"password";
$test+=+mysql_pconnect($hostname_test,+$username_test,+$password_test)+or+trigger_error(mysql_error(),E_USER_ERROR);+
mysql_query("SET+NAMES+UTF8");
?>|3293262|我的数据库排序规则是"utf8_general_ci“。|3293263|页面是"dreamweaver+default+utf8“和"unicode标准化form=C+(规范分解)”。|3293264|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$B|C]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|F|7|W|8|@]|9|@]|A|$]]]|P|$]]

<pre><code>mysql_query("SET NAMES UTF8");
</code></pre>

adding this line at the end of my "connection.php" solved my problem.

My connection file's complete code is:

<pre><code>&lt;?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_test = "localhost";
$database_test = "test";
$username_test = "username";
$password_test = "password";
$test = mysql_pconnect($hostname_test, $username_test, $password_test) or trigger_error(mysql_error(),E_USER_ERROR); 
mysql_query("SET NAMES UTF8");
?&gt;
</code></pre>

My database collation is "utf8_general_ci".

Pages are "dreamweaver default utf8" and "unicode normalisation form=C (Canonical Decomposition)".

blocks|key|328632|text|我最近遇到了这个问题(我希望和你有同样的问题)，我尝试了很多方法，但最后真正有效的方法是非常简单的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328633|将转储的SQL文件转换为UTF-8格式，然后将其导入。|328634|BW:我使用Notepad%2B%2B进行转换。|328635|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I had this problem recently (I hope its the same problem you are having), I tried many ways but at the end what worked was really simple.

Convert your dumped SQL file to UTF-8 format and then import it. 

BW: I used Notepad++ for the conversion.

blocks|key|325622|text|似乎并不是在MySQL中将每个SQL数据库、表和字段都设置为UTF-8，这已经足够好了。非常烦人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325623|最终迫使问题解决编码问题：|325624|每次打开数据库时都必须使用这个：$db->set_charset("utf8")；|325625|这招很管用。终于来了。|325626|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

It doesn't seem like setting every SQL Database, Table, and Field to UTF-8 in MySQL and is good enough. Very annoying.

Ended up forcing the issue to solve encoding problems:

Had to use this Every place I open the database:
$db->set_charset("utf8");

And that worked. Finally.

I moved data from MySQL 4 (they were originally set to <code>latin2 encoding</code>) to MySQL 5 and set encoding to <code>utf-8</code>. It looks good in <code>phpMyAdmin</code>, and <code>utf-8</code> is okay. However there are question marks instead of some characters on website! The website encoding is also set to <code>utf8</code> so I dont understand where the problem is. 

PHP and HTML files are also set to utf8.

I have no idea...

Issue with utf-8 encoding using PHP + MySQL

我将数据从MySQL 4 (最初设置为latin2 encoding)移动到MySQL 5，并将编码设置为utf-8。它在phpMyAdmin中看起来很好，而且utf-8也没问题。然而，网站上有问号而不是一些字符！网站编码也设置为utf8，所以我不知道问题出在哪里。PHP和HTML文件也被设置为utf8。我不知道。

问使用PHP + MySQL的utf-8编码问题
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PHP + MySQL的utf-8编码问题EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PHP + MySQL的utf-8编码问题
EN