After searching on the Internet for a long time, I finally found a solution, which is not perfect. My solution is to filter out the emoji characters and not write them to the mysql database.
The essence of emoji is special unicode characters, as long as your database encoding supports unicode.
List: http://www.unicode.org/charts/PDF/U1F300.pdf
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
After searching on the Internet for a long time, I finally found a solution, which is not perfect. My solution is to filter out the emoji characters and not write them to the mysql database.
The essence of emoji is special unicode characters, as long as your database encoding supports unicode. List: http://www.unicode.org/charts/PDF/U1F300.pdf
Just use utf8mb4 encoding for mysql