Unable to Insert smileys in database using Write to multiple data store entities

Hi Prateek,
I am able to store smileys with write to multiple data store.
Is there any possibility that error you are getting is not due to smiley? Most of the time we don't get proper alert message in "write to multiple data store".For testing, can you segregate all the DB call using "write to data store". It may happen that error you are getting is due to some other entity and record and not due to smiley. Please check and let us know.

Hi Prateek,
I am able to store smileys with write to multiple data store.
Is there any possibility that error you are getting is not due to smiley? Most of the time we don't get proper alert message in "write to multiple data store".For testing, can you segregate all the DB call using "write to data store". It may happen that error you are getting is due to some other entity and record and not due to smiley. Please check and let us know.

Hi umesh

Thanks for suggestion but I have tested this case for single entity only. As I mentioned that I got this error while trying to enter same data in same table using multiple data store entities(contains single entity only, as it is for testing purpose).

Just for confirmation, smileys which you are able to store in DB are of what type

1.  :) (This what we can type in from keyboard).

2.  Proper smiley which we generally use in chat apps (I am not able to attach it here).

Because if it is first case then there is no problem in either case. But in second case(proper smiley face) multiple data store is not able to convert it into proper Xml as what I figured out from alert.

Hi Prateek,

Its working for me in oracle DB. please check attached images.

May be its an issue with SQL Server Db to interpret emoji character. below link might be useful for you.

Below is the image of grid showing emoji.

Below is the image of DB table with emoji's

Are you having issues with any other unicode characters, or just smileys?

Hi Umesh,

I don't know why it is working in your case.

I have created a POC for this and tested it using both "Write to data store entity" & "Write to Multiple Data store entity" and it caused error for the later case.

I am attaching the screenshots of the issue in below attachment , If possible could you please check this and let me know if I am doing something wrong here:

Write to Multiple Data store entity issue.docx

Hi Mike,

I am encountering this issue for all emojis( be it smiley,High five etc.)

Hi Prateek,
Can you try using a!writeToMultipleDataStoreEntities function within your interface instead of using smart service node. Ideally this should not make any difference. But, lets try this.
If it fails, better to connect with Appian support to check this scenario.
Thanks.