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之前，charset选项被忽略.如果您运行的是旧版本的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屋！