The problem of emoji expression display in android app Development

I recently wrote an app similar to Qzone"s dynamic publication, which has no problem sending text and pictures. But if there is an emoji expression in the text, it will flicker. Here I would like to ask how to deal with a situation like this? The Internet is talking about using regular expressions to match pictures. Does that mean that app needs pictures with embedded emoji emoticons? And how should emoji expressions be stored in the database?

Jun.21,2022

is generally front-end processed. Emoji expressions seem to be unicode-encoded, which can be regularly deleted or processed. If you want to put them on the server side, you can convert them to the code, just like QQ and Wechat. Write a built-in library-sharp smile corresponds to Unicode code [U6...] Corresponding to emoji?

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-1b3ce7d-408da.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-1b3ce7d-408da.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?