PDO equivalent of mysql_client_encoding ()?

Question

Is there any way in PDO for checking client encoding, like in mysql / mysqli with mysql_client_encoding();?

PHP.net says that you can set the encoding with PDO::setAttribute(), for example:

$db->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES 'utf8'");

But how to get the current encoding?

+3

Joachim May 11 '12 at 13:41

1 answer

eggyal · Accepted Answer · 2012-05-11T15:19:54+0000

There are two different character sets:

encoding in which MySQL assumes that the rows are sent by the client ( character_set_client); and
the encoding in which MySQL will send its responses ( character_set_results).

To find out the current value of these variables using PDO, you can get the corresponding results SHOW VARIABLES; eg:

$qry = $db->query("SHOW VARIABLES LIKE 'character_set_client'");

character_set MySQL.

, , .

, MYSQL_ATTR_INIT_COMMAND DSN ( ):

$db = new PDO("mysql:dbname=$db;host=$host;charset=$charset", $user, $password);