Re: Error 2054 Server sent charset unknown to the client.

[Mark Hwang]

I am getting the same error from PDO. MySQL server returns "utf8" from SHOW VARIABLES LIKE 'character_set_system'. My code is as follows:

<?php
try {
$user = "test";
$pass = "test";
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);

$dbh = new PDO('mysql:host=localhost;dbname=vrg', $user, $pass, $options);
foreach($dbh->query('SELECT * from FOO') as $row) {
print_r($row);
}
$dbh = null;
}
catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>