Skip to main content
September 8, 2023
Solved

Error in Write to Data Store Entity "Incorrect string value: '\\xF0\\x9D\\x9B\\xBA\\x0A"

  • September 8, 2023
  • 1 reply
  • 0 views

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.

Best answer by stefanhelzle0001

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

1 reply

stefanhelzle0001
Brainy
September 8, 2023

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