Recently, in a mini program review, I wanted to support character emoticons and found that one character occupies four bytes. Therefore, I need to change the encoding format of the field and database to UTF8MB4. However, after changing the encoding format of the database, table, and field, the emoticon remains a question mark???

Need to change the fields and database to UTF8MB4 encoding format;

Record a mistake you made: not only do you need to modify the encoding format of the fields, but you also need to modify the encoding format of the tables and the config file of the MySQL database

Also, modify the character encoding format used when creating database links to ‘utf8mb4’

Previously, after modifying the encoding format in the first three places, no matter how much I tried, it didn’t work, and the expression remained the same???, It was found that the encoding format for creating database links in the code was still UTF-8, changed to UTF8MB4, and tried again