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

Question

Soma · Answer

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.

Stefan Helzle · Answer

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

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

Top Replies