PHP PDO:字符集，设置名称? [英] PHP PDO: charset, set names?

问题描述

我以前在我的普通 mysql_* 连接中有这个:

I had this previously in my normal mysql_* connection:

mysql_set_charset("utf8",$link);
mysql_query("SET NAMES 'UTF8'");

PDO 需要它吗?我应该在哪里拥有它?

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

$connect = new PDO("mysql:host=$host;dbname=$db", $user, $pass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

推荐答案

您将在连接字符串中使用它，例如:

You'll have it in your connection string like:

"mysql:host=$host;dbname=$db;charset=utf8"

然而，在 PHP 5.3.6 之前，字符集选项被忽略.如果您运行的是旧版本的 PHP，则必须这样做:

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:

$dbh = new PDO("mysql:$connstr",  $user, $password);
$dbh->exec("set names utf8");

这篇关于PHP PDO:字符集，设置名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！