How to convert Unicode characters to emojis. Our process saves the emojis to Cloud DB as "utf8mb4_general_ci". I want to show them as emojis on the richTextFieldWithTables

for example in UI it shows:

testing for emojis\r\n\r\n\U0001f600 \U0001f603 \u263a\ufe0f \U0001f60e \U0001f480 \u2620\ufe0f \U0001f47d \U0001f47e \U0001f916\r\n\r\n\u261d\ufe0f \U0001f44d \U0001f44e \U0001f64f\r\n\r\n\U0001f4af \u2618\ufe0f \U0001f381 \U0001f480\r\n\r\n\U0001f600\U0001f62a\U0001f648\U0001f3a8\U0001f381\U0001f953\U0001f6f4\U0001f494

Instead of:

testing for emojis

[emoticon:44a8a53ad3364ea78a16c5a3229f75bb] [emoticon:6d505171faa4497c85c5ca27290c555d] [emoticon:fbd079a1c4f748c5a234faee215de9cc]️ [emoticon:0e469978eb8947d18b9c41123db3725a] [emoticon:8c5635365c6e44258a71962443ac45a8] [emoticon:c640fd57eca649f0b3756ec81e528d5c]️ [emoticon:06c758f283ba4953b3300810a3649c32] [emoticon:433e72b450e24324b8c55272d7f50a87] [emoticon:2d6f789653e1461e8dd13b99016436b3]

[emoticon:3d95d7926d0f4938aeae7bf446438c80]️ [emoticon:1435ff2429184e17bc948e4f19178e1e] [emoticon:5a0f14c278ae4acab4f730543d564199] [emoticon:4baf9c67c1b843c6b4ddedea33023652]

[emoticon:9b06bfad0e6a482e801e5eb8fd9025d6] [emoticon:e1032f42252d4c5c84946e1b43558ed7]️ [emoticon:8416d71642834782a5fe858404490f18] [emoticon:8c5635365c6e44258a71962443ac45a8]

[emoticon:44a8a53ad3364ea78a16c5a3229f75bb][emoticon:8fbf4ba171e24a4584fd0845f27df978][emoticon:fb5664f7c89249e9adaf75f36158e69e][emoticon:520e0b02a9184ee7ab9d3b320abb1e29][emoticon:8416d71642834782a5fe858404490f18][emoticon:a85cd08878fa4046b411e7045b7153ae][emoticon:2de226761c874098abb400742fe9cf81][emoticon:29428496fffa4e7986a5b2398d109a9c]

Did you already tried your approach?

That richTextField takes HTML, I think you should be able to use the HTML notation to show these characters. But it might be difficult to identify them.

https://www.w3schools.com/charsets/ref_utf_symbols.asp

The emojis are stored as unicode characters. AFAIK, Appian does not display the icon related to unicode value. We have to do some string manipulation to achieve it. 

One option is to use char() function along with hex2dec() function. Please find attached screenshot.