Use nodejs's mysql library to insert emoji emoticons into mysql and report errors, as well as reading

1 br Nodejs inserts data into the data
clipboard.png
2mysql
utf8mb4
clipboard.png
3,
clipboard.png
the front end uses react+redux,
4. I guess the problem lies in the character encoding here

.
Mar.01,2021

has been solved, not only to change the database character set to the specified utf8mb4, data connection, but also to set chatset to utf8mb4
reference 1:mysql npmjs
Ref. 2: blog

clipboard.png

Menu