PDO mysql php accentuation problem

Question

I am using this class to manipulate records in Mysql using PDO http://www.imavex.com/php-pdo-wrapper-class/

But I suggest ééé and inserts me éé at the bank

the database is uft8 the script header is in uft8.

Answer 1

Try applying the Character set directly to the DB call like this:

$db = new db("mysql:host=127.0.0.1;port=8889;dbname=mydb", charset=UTF8, "dbuser", "dbpasswd");
$db->exec("SET CHARACTER SET utf8");

or in the class constructor:

$options = array(
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
); 
public function __construct($dsn, $user="", $passwd="", $options) {
  //
}