My application does not save accented data correctly

Question

I’m developing a web application with Extjs 4 and PHP. I’m having trouble doing the INSERT in the database. For example, I registered the product "tea", but it saves "chu00e1". My entire database is in UTF-8, my PHP files are with header in UTF-8, my HTML too, I am saving my files in UTF-8, IE, everything is with the same encoding.

Below is the line of code where I do the INSERT.

<?php
//chama o arquivo de conexão com o bd
include("connect.php");

$info = $_POST['data'];

$data = json_decode(stripslashes($info));

$codigo = $data->codigo;
$nome = $data->nome;
$descricao = $data->descricao;
$quantidade = $data->quantidade;
$sigla = $data->sigla;


$query = sprintf("INSERT INTO produtos (codigo, nome, descricao, quantidade, sigla) values ('%s', '%s', '%s', '%d', '%s')",
    mysql_real_escape_string($codigo),
    mysql_real_escape_string($nome),
    mysql_real_escape_string($descricao),
    mysql_real_escape_string($quantidade),
    mysql_real_escape_string($sigla));

$rs = mysql_query($query);

echo json_encode(array(
    "success" => mysql_errno() == 0,
    "data" => array(
        "id" => mysql_insert_id(),
        "codigo" => $codigo,
        "nome" => $nome,
        "descricao" => $descricao,
        "quantidade" => $quantidade,
        "sigla" => $sigla
    )
));
?>

Answer 1

It is likely that the transport of Mysql data from the PHP library to the driver is with another encoding. I mean, the page is with the right coding, the database is recording things in UTF-8, but what comes to it may not be UTF-8.
To make sure of that, in your connect.php, run the following query:

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $conexao);  

This will prevent you from having to convert (use utf8_encode() or utf8_decode()) when recording or displaying. It should work if everything is in UTF-8 as you say.

EDIT:

Actually the problem was the function stripslashes that removes the Unicode encoding bar (Format: u0000) placed by JSON in the POST, causing the encoding to be out of character.
I will leave the original answer because it may help in cases of accentuation problems, but I know that is not the right answer in the case of the question.