Character encoding issue MySQL

Asked Nov 23 '14 at 13:55

Active Nov 23 '14 at 13:55

Viewed 26 times

I'm trying to store strings that contains special characters with MySQL (PHP with PDO).

I've created a UTF-8 php project in netbeans and utf8_general_ci tables in MySQL. The page header contains <meta charset="UTF-8"> already.

When i store the word 'Acentuação', it appears to me as 'AcentuaÃ§Ã£o' (tried w/ phpmyadmin 4.1.14 and Heidisql 9.1 - http://www.heidisql.com/)

Im missing something? Thanks in advance

asked Nov 23 '14 at 13:55

CarlosCarucce

2

Take a look here http://stackoverflow.com/questions/279170/utf-8-all-the-way-through – Mihai Nov 23 '14 at 13:57
1

Thank you @Mihai . I was missing the connection char-encoding: `$dbh = new PDO('mysql:charset=utf8mb4');` – CarlosCarucce Nov 23 '14 at 14:09

0 Answers0