JQuery将HTML实体/表情符号发布到PHP服务器

Question

I'm using JQuery to serialize and post form values to a PHP/MySQL server, and the form textarea contains text and emojis as HTML entities:

<textarea>Hello &#x1f600; and goodbye</textarea>

The server receives:

Hello \ud83d\ude00 and goodbye

However, only "Hello" gets stored in the database correctly. The emoji/entity and any text after it disappear. The database gets:

Hello

Everything is UTF-8 throughout.

What's the right way to parse this into something that can be stored and then returned back into HTML in a way that it renders properly? I must be overlooking something simple.

Answer 1

Solved.

Either change database/table collation, as per Andy Foster in the comments below the question, or JSON encode/decode to ensure it gets saved properly as a string.

json_encode($str);
json_decode($str);

In my case, there were three things affecting encoding/rendering:

1) Initial submit using JQuery serialize() which converted the emoji into a Unicode escape sequence.

2) Saving the Unicode escape sequence into database. I used JSON encoding to get past this.

3) Output escaping when rendering the JSON-decoded emoji string back into an HTML template.