Skip to main content
J
jyotig0003
June 8, 2023
Question

Saving Emoji and special characters to Appian Cloud database

  • June 8, 2023
  • 7 replies
  • 0 views

Hi Experts,

I  want to insert Emojis and special characters  with text . Is there any  way to insert in Database?

Thanks

7 replies

stefanhelzle0001
stefanhelzle0001
June 8, 2023

I am not sure what your question is about. There is nothing special about emojis.

Just make sure that the field is of type UTF8MB4 instead of UTF8MB3. Then you can store any character.

    harshitb6843
    harshitb6843
    June 8, 2023

    nvarchar should get you covered. 

    stefanhelzle0001
    stefanhelzle0001
    June 8, 2023

    The collation of the field needs to be "utf8mb4_general_ci". This can also be set for the whole table in table options.

    J
    jyotig0003Author
    June 9, 2023

    Hi Stefan ,

    I tried this but it is not  working . 
    I  want to save in DB like:
    example: ertyuiopasdfghjklvbnm 
    antons0003
    antons0003
    June 9, 2023

    I'm not sure how Appian parse an emoji as I'm not currently passed full course, but you could refer next resource to check for UTF-8 and other encodings database supports and Appian as well. You need to store a code of this emoji, so, if Appian parses Java emoji encoding, it could be value:

    "\uD83E\uDD23"

    Without double quotes.

    Hope it will help.

    Best, Anton.

    Terms & ConditionsAccessibility statement