note 100414 deleted from pdo.connections by frozenfire
| From: | frozenfire@php.net | Date: | Thu, 04 Jul 2013 02:39:31 +0000 |
| Subject: | note 100414 deleted from pdo.connections by frozenfire | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-195452@lists.php.net to get a copy of this message | ||
Note Submitter: ekkart at ekkart dot de
----
In order to set the encoding of the database connection, use the exec function:
<?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
$dbh->exec("SET CHARACTER SET utf8");
$dbh = null;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>