Skip to main content
New Participant
Oct 28, 2024 4:53 PM UTC
Question

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

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

    3 replies

    New Participant
    Oct 28, 2024 5:07 PM UTC

    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]

    stefanhelzle0001
    Brainy
    Oct 28, 2024 5:07 PM UTC

    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

    somasundaram.d
    Employee
    Oct 29, 2024 1:32 PM UTC

    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.