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

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b32ed5-2be5a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b32ed5-2be5a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?