change database encoding

Asked Dec 23 '16 at 11:06

Active Dec 27 '16 at 05:25

Viewed 38 times

Can anybody helps me in how to change the encoding of the database, because when I try to execute the following query :

 $stmt=$conn->prepare("INSERT INTO photo (id_user,name) VALUES(:id_user,:name)");
    $stmt->execute(array(
        "id_user" => 1,
        "name" => 'allèèeeâ'
        ));

In the database I get the following result : allÃ¨Ã¨eeÃ¢. I tried to run the following command to solve the problem :

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

But it did not solve the problem.

Thank you for your help.

edited Dec 27 '16 at 05:25

Isaac Bennetch

11,830
2
32
43

asked Dec 23 '16 at 11:06

khalid essalhi

Try with this query : http://stackoverflow.com/a/30223807/4952944. it may be work. – Bhavin Dec 23 '16 at 11:31
Are you connecting via putty or similar? If so ensure the putty character encoding isn't confounding your error, when the data is actually stored and retrieved correctly. – James Scott Dec 23 '16 at 13:51
I'am using wamp server (Apache). – khalid essalhi Dec 23 '16 at 14:13
See http://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored ; look for "Mojibake". – Rick James Dec 24 '16 at 02:14

change database encoding

0 Answers0