Hi everyone,
On a process instance, I'm trying to Write on Data Store Entity a string value with the following characters: Ω μs.
But instead, I have the following error: "javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: java.sql.SQLSyntaxErrorException: (conn=364712) Incorrect string value: '\xF0\x9D\x9B\xBA\x0A ...' "
The field where I'm trying to store the value is varchar(4000), in Appian's database cloud mariadb.
Discussion posts and replies are publicly visible
Seems like your database table is set to use a UTF8MB3 collation. Change it to UTF8MB4 and you should be good.
community.appian.com/.../kb-2038-issues-writing-to-mysql-database-when-emojis-or-unicode-characters-are-used