MySQL-PDO 创建时如何指定字符集设置

Question

在new PDO 对象时如何直接设置 字符集呢??

在 netbeans 自带的实例中 在dsn后虽然 指定了 charset 但是校验之后得出,不同版本并不能正常运行... 求解

Answer 1

我当前的解决思路是:

$this->db = new PDO($this->config['dsn'], $this->config['username'], $this->config['password']);
if (isset($this->config['init_command']) && !empty($this->config['init_command'])){
if (is_string($this->config['init_command'])){
self::log($this->config['init_command']);
$this->db->exec($this->config['init_command']);
}
}

SqlDbFactory::instance(array(
'dsn' => "mysql:host=localhost;dbname=telecom_web;",
'username' => 'root',
'password' => '1111',
'init_command' => 'SET NAMES utf8'
))

求更好的方法