PDO连接AWS RDS字符集

Question

当尝试通过PDO连接到AWS RDS数据库时，我得到

"Erreur : SQLSTATE[HY000] [2054] Server sent charset unknown to the client"

我在某个地方读到，我可以尝试更改我的.cnf文件
我没有找到，所以在Applications/MAMP/conf中创建了它，并放入

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

但它仍然不起作用。。。(我正在使用MAPMP和php 7.0.15的Mac电脑(谢谢

Answer 1

字符集应该是-

PDO:：MYSQL_ATTR_INIT_COMMAND=>"设置名称utf8">

这是PDO连接代码示例-

$host = "asjhdkjashdkj.asjdhaskd.ap-southeast-1.rds.amazonaws.com";
$username = "user";
$password = "pass";
$db_name = "database";
return new PDO('mysql:host=' . $host . ';dbname=' . $db_name, $username, $password, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));