Hi Experts,
I want to insert Emojis and special characters with text . Is there any way to insert in Database?
Thanks
Discussion posts and replies are publicly visible
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.
nvarchar should get you covered.
The collation of the field needs to be "utf8mb4_general_ci". This can also be set for the whole table in table options.
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.
Hi Stefan ,
I tried this but it is not working . I want to save in DB like:example: ertyuiopasdfghjklvbnm
Hello. You could try this string as in your example:
ertyuiopasdfghjklvbnm\uD83D\uDE09\uD83D\uDE09\uD83D\uDE17\uD83D\uDE03\uD83D\uDE03It will store the encoded values of emojis and after retrieval from database and rendering on the web page it will be displayed as typical icon
ertyuiopasdfghjklvbnm\uD83D\uDE09\uD83D\uDE09\uD83D\uDE17\uD83D\uDE03\uD83D\uDE03
Please explain what you mean with "it is not working".
I can copy the string you posted and store it in my database.