Hello,
I have a requirement to store smileys in Database(SQL server). A user enters a value in a paragraph field and insert some smileys along with text, It is a free text field.
When I tried to store the user entered value in Database using "Write to data store entity" smart service then it get stored successfully in DB but when I tried to store the same value into the same table using "Write to multiple Data Store entities" smart service then I am getting below error:
XML handling failure trying to convert value EntityData [entity=DataStoreEntityRef[id=02377f7c-84c4-4948-9170-470ec382075e@22976, uuid=null], data=[TypedValue[it=3921,v={7,via Multiple data store }]]] to Appian type EntityData (id=2134).
I can store values in DB using "Write to data store entity" Smart service but I want to know why the same case can't be handled with "Write to multiple Data Store entities".
Suggestion much appreciated!!
Discussion posts and replies are publicly visible
Hi Eliot Gerson .
I have already checked this documentation page and as per documentation for SQL Server- No additional configuration required. Actually This is Appian product issue. We have raised a support case for its resolution and Appian team has confirmed that they are also able to replicate this issue. As of now we are awaiting their response for its resolution.
Hi PRATEEK BHATTI,
Did the Appian team ever get back to you with a solution?
The solution is well known and means to change the character set of the db table to 4-Byte Unicode.
community.appian.com/.../kb-2038-issues-writing-to-mysql-database-when-emojis-or-unicode-characters-are-used