we have a scenario where the user can enter the special characters in one of t

rajashekarv over 9 years ago

we have a scenario where the user can enter the special characters in one of the fields through the excel upload option we have on our app , these characters are treated well in the Appian ,but when we try to insert the data with these special Characters into the database we get an exception .
Is there a way in Appian to escape all these special characters before we insert into DB ?

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 9 years ago

I had a case where a user pasted some formatting character into a paragraph field (my guess is that it was a weird bullet point, copied out of a Word document), which caused a failure during the Write to DS. This environment is cloud-based and the DB is utf8 unicode. It's only happened once in over a year in production, so there's that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 9 years ago

I had a case where a user pasted some formatting character into a paragraph field (my guess is that it was a weird bullet point, copied out of a Word document), which caused a failure during the Write to DS. This environment is cloud-based and the DB is utf8 unicode. It's only happened once in over a year in production, so there's that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data