Symfony2 - Characters change from my database MySQL in a json response

Question

I'm developing a web application with Symfony and MySQL as database. My database creation syntax is as below:

CREATE DATABASE `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

The table which I need to know why is returning unexpected text is:

CREATE TABLE `elements` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL
)ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

And the entity code in PHP is:

/**
 * 
 *
 * @ORM\Table(name="elements")
 * @ORM\Entity()
 */
class Element
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=100)
     */
    private $name;
}

When the name of the Element has Spanish characters like á,é,í,ó,ú,ñ; in the browser is correctly rendered, and in the database the characters are stored in this way, but when I try to return this information using a JsonResponse, the characters are converted to others codes. For example:

$result['id']       = $e->getId();
$result['name']     = $e->getName();

return new JsonResponse( array('response' => $result) );

And the response shows:

"response":{
    "id":26,
    "name":"Avi\u00f3n"
}

And name should be "Avión" instead.

I would like to know why this happens and how can avoid this behavior. Any ideas?

Thanks in advance.

Community · Accepted Answer · 2017-05-23 10:30:05Z

2

I don't see actual problem here.

They are not converted to other codes.

Instead, they are utf-8 encoded (default JSON encoding).

Some info : RFC4627 section 2.5 strings

\u00F3 is utf-8 encoded character ó, see here

UPDATE:

Read this : JSON Encoding and decoding of UTF8 characters in PHP

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered May 14, 2014 at 13:49

rkosegi

14.8k5 gold badges57 silver badges90 bronze badges

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

3 Comments

Javad Over a year ago

Just wanted to add this comment to accomplish your answer: To decode the encoded JSON in client side (e.g. jQuery) he might want to change the headers Content-Type to application/json; charset=utf-8, because that's what the client side is expecting for. It's always good to make things consistent. Right?

Airam Over a year ago

Thanks for the answer @rkosegi. I voted up your answer.

rkosegi Over a year ago

@Javad, agree with you, by explicitly setting encoding on client side you don;t break anything, but makes think more compliant.

Community · Accepted Answer · 2023-11-20 22:45:59Z

1

When you called new JsonResponse($data), among other things, your data is encoded in this way:

json_encode($data, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT);

By default, json_encode escapes unicode characters, so the output you get is the expected one. If you don't want to have your unicode escaped, you can create your controller response as follow:

$data = array('response' => $result);
return new Response( json_encode($data, JSON_UNESCAPED_UNICODE | JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT));

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered May 14, 2014 at 14:35

Victor Henriquez

1,44916 silver badges26 bronze badges

1 Comment

Robert Mihai Ionas Over a year ago

return new JsonResponse( json_encode(['message' => 'success','result'=>$result], JSON_UNESCAPED_UNICODE | JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT), Response::HTTP_OK, ['charset'=>'UTF-8','Access-Control-Allow-Origin'=>'*'], true); to have headers set content-type application/json and other custom

Collectives™ on Stack Overflow

Symfony2 - Characters change from my database MySQL in a json response

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related