/ Windows /

phalcon MYSQL数据库字符串编码

Phalcon在写中文入数据库的时候，经常会出现乱码，需要在di设置数据库的时候给数据库设置编码。


$di["db"] = function() {
return new \Phalcon\Db\Adapter\Pdo\Mysql(array(
"host" => "localhost",
"username" => "root",
"password" => "1234",
"dbname" => "test",
"options" => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
)
));
};


或者

$db = new \Phalcon\Db\Adapter\Pdo\Mysql(array(
"host" => "localhost",
"username" => "root",
"password" => "1234",
"dbname" => "test",
'charset' =>'utf8'
));