在mysql表中保存Ø而不是Ã〜

Question

My table look like this:

CREATE TABLE `friends` 
(
    `id` bigint(20) NOT NULL default '0',
    `fb_id` bigint(20) NOT NULL default '0',
    `name` varchar(100) NOT NULL default '',

) TYPE=MyISAM charset=utf8;

I add to the db like this:

            $sql = "insert ignore into `friends` (`id`, `fb_id`, `name`)" .
                            "values (:id, :fb_id, :name)";
                try 
                {
                    $stmt = $this->db->prepare($sql); 
                    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
                    $stmt->bindParam(':fb_id', $fb_id, PDO::PARAM_INT);
                    $stmt->bindParam(':name', $name, PDO::PARAM_STR);

                    $result = $stmt->execute();
                    $stmt->closeCursor(); 
                }       
                catch (Exception $e)
                {
                die ($e->getMessage() ); 
                }

How can I saveØystein and not Øystein. I have set the charset to utf8 not sure what more I can do.

EDIT:

Upgraded my db_connect function:

        $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME;
        $driver_options = array( PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8' );

        try
        {
            $this->db = new PDO($dsn, DB_USER, DB_PASS, $driver_options);
        }

Still got the same problem..

Answer 1

Try adding $this->db->exec('SET CHARACTER SET utf8') after connecting to the DB.