Hi there, we have a problem with unicode support on Appian cloud at two customer

Stefan Helzle

A Score Level 3

over 8 years ago

Hi there, we have a problem with unicode support on Appian cloud at two customers. A user pastes a emoji into a text field which is saved to datastore in process. The "Write to datastore" node breaks. After digging a bit I found out that MySQL is not configured to handle unicode correctly. The default charsets in MySQL are not able to save 4-byte characters. Is there anyone having a similar problem?

Discussion posts and replies are publicly visible

Parents

0 Josh
Certified Lead Developer
over 8 years ago

Hi stefan, we have a similar issue on our project. Our workaround is to strip all unknown characters before saving into a rule input. Ex. a!save(ri!input, rule!strip(save!value)) where rule!strip is cleanwith(ri!text," abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%^&*()`~-_=+{}|:<>?[]\\;',./""")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Josh
Certified Lead Developer
over 8 years ago

Hi stefan, we have a similar issue on our project. Our workaround is to strip all unknown characters before saving into a rule input. Ex. a!save(ri!input, rule!strip(save!value)) where rule!strip is cleanwith(ri!text," abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%^&*()`~-_=+{}|:<>?[]\\;',./""")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data