I want to add "💩" to ticket description field and get error:
Exception occurred: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Issue][description,屪λ💩][id,246754][updated,2016-09-29 12:03:36.58] (SQL Exception while executing the following:UPDATE jiraissue SET DESCRIPTION=?, UPDATED=? WHERE ID=? (Incorrect string value: '\xF0\x9F\x92\xA9' for column 'DESCRIPTION' at row 1))
Let me guess, MySQL database on the back end?
The recommended config for MySQL doesn't support the higher end unicode characters. It's caused us huge problems when people had used emojis in their data and we were trying to migrate on to MySQL. We could have stripped them, but the easier option at that time was to jump to PostGreSQL instead.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG