blocks|key|857416|text|您将在您的连接字符串中包含它，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857417|"mysql:host=$host;dbname=$db;charset=utf8"|code-block|syntax|javascript|857418|但是，在PHP+5.3.6之前，charset选项被忽略。如果你运行的是一个旧版本的PHP，你必须这样做：|857419|$dbh+=+new+PDO("mysql:$connstr",++$user,+$password);
$dbh->exec("set+names+utf8");|857420|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|$]]

You'll have it in your connection string like:

<pre><code>"mysql:host=$host;dbname=$db;charset=utf8"
</code></pre>

HOWEVER, prior to PHP 5.3.6, the charset option was ignored. If you're running an older version of PHP, you must do it like this:

<pre><code>$dbh = new PDO("mysql:$connstr", $user, $password);
$dbh-&gt;exec("set names utf8");
</code></pre>

blocks|key|1072062|text|在PHP+5.3.6之前，charset选项被忽略。如果你运行的是一个旧版本的PHP，你必须这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072063|<?php

++++$dbh+=+new+PDO("mysql:$connstr",++$user,+$password);

++++$dbh+->+exec("set+names+utf8");

?>|code-block|syntax|javascript|1072064|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Prior to PHP 5.3.6, the charset option was ignored. If you're running an older version of PHP, you must do it like this:

<pre><code>&lt;?php

 $dbh = new PDO("mysql:$connstr", $user, $password);

 $dbh -&gt; exec("set names utf8");

?&gt;
</code></pre>

blocks|key|857556|text|这可能是最优雅的方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857557|就在PDO构造函数调用中，但要避免使用错误字符集选项(如上所述)：|857558|$connect+=+new+PDO(
++"mysql:host=$host;dbname=$db",+
++$user,+
++$pass,+
++array(
++++PDO::ATTR_ERRMODE+=>+PDO::ERRMODE_EXCEPTION,
++++PDO::MYSQL_ATTR_INIT_COMMAND+=>+"SET+NAMES+utf8"
++)
);|code-block|syntax|javascript|857559|对我来说很有用。|857560|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This is probably the most elegant way to do it. 
Right in the PDO constructor call, but avoiding the buggy charset option (as mentioned above):

<pre><code>$connect = new PDO(
 "mysql:host=$host;dbname=$db", 
 $user, 
 $pass, 
 array(
 PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION,
 PDO::MYSQL_ATTR_INIT_COMMAND =&gt; "SET NAMES utf8"
 )
);
</code></pre>

Works great for me.

blocks|key|1072011|text|我认为您需要一个额外的查询，因为DSN中的charset选项实际上被忽略了。请看另一个答案的评论中的链接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072012|看看Drupal7是如何在http://api.drupal.org/api/drupal/includes--database--mysql--database.inc/function/DatabaseConnection_mysql%253A%253A__construct/7中做到这一点的|offset|length|1072013|//+Force+MySQL+to+use+the+UTF-8+character+set.+Also+set+the+collation,+if+a
//+certain+one+has+been+set;+otherwise,+MySQL+defaults+to+'utf8_general_ci'
//+for+UTF-8.
if+(!empty($connection_options['collation']))+{
++$this->exec('SET+NAMES+utf8+COLLATE+'+.+$connection_options['collation']);
}
else+{
++$this->exec('SET+NAMES+utf8');
}|code-block|syntax|javascript|1072014|entityMap|0|LINK|mutability|MUTABLE|url|http://api.drupal.org/api/drupal/includes--database--mysql--database.inc/function/DatabaseConnection_mysql%253A%253A__construct/7^0|0|D|3H|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|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I think you need an additionally query because the charset option in the DSN is actually ignored. see link posted in the comment of the other answer.

Looking at how Drupal 7 is doing it in <a href="http://api.drupal.org/api/drupal/includes--database--mysql--database.inc/function/DatabaseConnection_mysql%3A%3A__construct/7" rel="nofollow noreferrer">http://api.drupal.org/api/drupal/includes--database--mysql--database.inc/function/DatabaseConnection_mysql%3A%3A__construct/7</a>:

<pre><code>// Force MySQL to use the UTF-8 character set. Also set the collation, if a
// certain one has been set; otherwise, MySQL defaults to 'utf8_general_ci'
// for UTF-8.
if (!empty($connection_options['collation'])) {
 $this-&gt;exec('SET NAMES utf8 COLLATE ' . $connection_options['collation']);
}
else {
 $this-&gt;exec('SET NAMES utf8');
}
</code></pre>

blocks|key|1072166|text|$con="";
$MODE="";
$dbhost+=+"localhost";
$dbuser+=+"root";
$dbpassword+=+"";
$database+=+"name";

$con+=+new+PDO+(+"mysql:host=$dbhost;dbname=$database",+"$dbuser",+"$dbpassword",+array(PDO::MYSQL_ATTR_INIT_COMMAND+=>+"SET+NAMES+utf8"));
$con->setAttribute+(+PDO::ATTR_ERRMODE,+PDO::ERRMODE_EXCEPTION+);+++|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1072167|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$con="";
$MODE="";
$dbhost = "localhost";
$dbuser = "root";
$dbpassword = "";
$database = "name";

$con = new PDO ( "mysql:host=$dbhost;dbname=$database", "$dbuser", "$dbpassword", array(PDO::MYSQL_ATTR_INIT_COMMAND =&gt; "SET NAMES utf8"));
$con-&gt;setAttribute ( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); 
</code></pre>

blocks|key|857608|text|我只想补充一点，你必须确保你的数据库是用COLLATE+utf8_general_ci或任何你想要使用的排序规则创建的，否则你可能会得到另一个比你想要的结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857609|在phpmyadmin中，您可以通过单击数据库并选择操作来查看排序规则。如果您尝试使用数据库之外的其他排序规则创建表，则无论如何，您的表都将以数据库排序规则结束。|857610|因此，在创建表之前，请确保数据库的排序规则是正确的。希望这能帮你节省几个小时|857611|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 just want to add that you have to make sure your database is created with COLLATE utf8_general_ci or whichever collation you want to use, Else you might end up with another one than intended.

In phpmyadmin you can see the collation by clicking your database and choose operations. If you try create tables with another collation than your database, your tables will end up with the database collation anyways.

So make sure the collation for your database is right before creating tables. Hope this saves someone a few hours lol

blocks|key|1072192|text|我测试了这段代码，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072193|$db=new+PDO('mysql:host=localhost;dbname=cwDB','root','',
array(PDO::MYSQL_ATTR_INIT_COMMAND+=>+"SET+NAMES+utf8"));
$sql="select+*+from+products++";
$stmt=$db->prepare($sql);
$stmt->execute();
while($result=$stmt->fetch(PDO::FETCH_ASSOC)){++++++++++++++++++
++++$id=$result['id'];
}|code-block|syntax|javascript|1072194|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I test this code and

<pre><code>$db=new PDO('mysql:host=localhost;dbname=cwDB','root','',
array(PDO::MYSQL_ATTR_INIT_COMMAND =&gt; "SET NAMES utf8"));
$sql="select * from products ";
$stmt=$db-&gt;prepare($sql);
$stmt-&gt;execute();
while($result=$stmt-&gt;fetch(PDO::FETCH_ASSOC)){ 
 $id=$result['id'];
}
</code></pre>

blocks|key|1072244|text|$conn+=+new+PDO("mysql:host=$host;dbname=$db;charset=utf8",+$user,+$pass);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1072245|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$conn = new PDO("mysql:host=$host;dbname=$db;charset=utf8", $user, $pass);
</code></pre>

blocks|key|1072265|text|在我的例子中，我必须添加下面这一行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072266|$conn->exec("set+names+utf8");+//Support+utf8|code-block|syntax|javascript|1072267|它看起来是什么样子：|1072268|$conn+=+new+PDO("mysql:host=$servername;dbname=$db",+$username,+$password);
$conn->exec("set+names+utf8");+//Support+utf8|1072269|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|$]]

in my case, i had to add this line:
<pre><code>$conn-&gt;exec(&quot;set names utf8&quot;); //Support utf8
</code></pre>
How it will look:
<pre><code>$conn = new PDO(&quot;mysql:host=$servername;dbname=$db&quot;, $username, $password);
$conn-&gt;exec(&quot;set names utf8&quot;); //Support utf8
</code></pre>

I had this previously in my normal mysql_* connection:

<pre><code>mysql_set_charset("utf8",$link);
mysql_query("SET NAMES 'UTF8'");
</code></pre>

Do I need it for the PDO? And where should I have it?

<pre><code>$connect = new PDO("mysql:host=$host;dbname=$db", $user, $pass, array(PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION));
</code></pre>

PHP PDO: charset, set names?

我以前在正常的mysql_*连接中有这个：mysql_set_charset("utf8",$link);mysql_query("SET NAMES 'UTF8'");我的PDO需要它吗？我应该把它放在哪里呢？$connect = new PDO("mysql:host=$host;dbname=$db", $user, $pass, array(PDO::ATTR_ERRMODE => PDO

问PHP PDO:字符集，集名？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP PDO:字符集，集名？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP PDO:字符集，集名？
EN