Cakephp显示符号表和python编码（'unicode-escape'）相关的问题

Question

In my table, I have a row like this:

Amazing ...

Answer 1

I also had same problem before. The thing is the utf8 encoding only supports three bytes per character. You can read detail here

MySQL’s utf8 isn’t UTF-8. So, you can't save some char and emoji and sometime it may cut off your text.

What I did is I applied utf8mb4 to all table and schema.

E.g

`ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`

`ALTER SCHEMA `your_schema`  DEFAULT CHARACTER SET utf8mb4  DEFAULT COLLATE utf8mb4_unicode_ci;`

After onward, happy to saved emoji character as well :).