Uploaded image for project: 'Jira Service Management Server and Data Center'
  1. Jira Service Management Server and Data Center
  2. JSDSERVER-3411

As admin, would like issue creation from email accept email with emoticon

    XMLWordPrintable

    Details

    • UIS:
      2
    • Support reference count:
      9
    • Feedback Policy:
      We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Description

      NOTE: This suggestion is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? See the corresponding suggestion.

      Problem Definition

      Currently, when an email have emoticons in it, the issue creation will be rejected by JIRA Service Desk if MySQL is used as the JIRA database.

      In the log, the following error should be seen:

      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, issuenum, PROJECT, REPORTER, ASSIGNEE, CREATOR, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x9F\xA4\x94\x0D\x0A...' for column 'DESCRIPTION' at row 1)
      

      Cause

      This is because email emoticons use 4-byte characters, while MySQL doesn't support this:

      Suggested Solution

      JIRA Service Desk should auto render the emoticons as text, so that issues will be successfully created.

      This will also work if 4-byte characters are supported in MySQL.

      Workaround

      Switch to a different type of supported databases: Postgre, MS SQL, or Oracle.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              nroslan Atiqah Roslan
              Votes:
              23 Vote for this issue
              Watchers:
              26 Start watching this issue

                Dates

                Created:
                Updated:

                  Backbone Issue Sync