PHP MySQL - Charset not taken into consideration

Question

I have a php file that inserts data to a mysql db using pdo. When I try to insert the word référencé in a field in one of my table, it is showing in mysql like rÃ©fÃ©rencÃ©
I do not get it as I specified a little everywhere the charset as utf-8. See below.

my table is set to innodb utf-8
my field is set to utf8_general_ci
at the top of my php script i put
a. header('Content-Type: text/html; charset=utf-8');
b. mysql_set_charset('utf8');
c. mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");

Here below my pdo connexion function:

function connexion($host, $user, $pass, $db){
    $db_host = $host;  
    $db_user = $user;  
    $db_password = $pass;  
    $db_database = $db;               
    return $connexion = new PDO("mysql:host=$db_host;dbname=$db_database", $db_user, $db_password);
}

Hope someone can help me understand. Thank you in advance. Cheers. Marc

Try executing "SET NAMES UTF8" query in MySQL as well. Also how do you display the data? It might be insterted properly but the encoding might brake where you display it. — ddinchev
– ddinchev, Commented Apr 25, 2012 at 10:46
And are you setting the connection encoding for that PDO connection somewhere as well? — deceze
– deceze ♦, Commented Apr 25, 2012 at 10:50
@deceze I hust edited my post and added my pdo connecxion function — Marc
– Marc, Commented Apr 25, 2012 at 10:51

deceze · Accepted Answer · 2012-04-25 10:57:24Z

2

Well, apparently you're not setting the connection encoding for your PDO connection. Do it like so:

return new PDO("mysql:host=$db_host;dbname=$db_database",
               $db_user,
               $db_password,
               array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));

See http://php.net/manual/en/ref.pdo-mysql.connection.php.

answered Apr 25, 2012 at 10:57

deceze♦

525k89 gold badges807 silver badges954 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP MySQL - Charset not taken into consideration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related