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

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

XMLWordPrintable

    • 4
    • 19
    • 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.

      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.

        1. Screen Shot 2016-02-15 at 3.57.25 PM.png
          Screen Shot 2016-02-15 at 3.57.25 PM.png
          62 kB

            [JSDSERVER-3411] As admin, would like issue creation from email accept email with emoticon

            SET Analytics Bot made changes -
            Support reference count Original: 9 New: 19
            Marc Dacanay made changes -
            Labels Original: affects-server New: affects-server ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 976631 ]
            SET Analytics Bot made changes -
            UIS Original: 3 New: 4
            SET Analytics Bot made changes -
            UIS Original: 8 New: 3
            SET Analytics Bot made changes -
            UIS Original: 9 New: 8
            SET Analytics Bot made changes -
            UIS Original: 8 New: 9
            SET Analytics Bot made changes -
            UIS Original: 7 New: 8
            SET Analytics Bot made changes -
            UIS Original: 8 New: 7
            SET Analytics Bot made changes -
            UIS Original: 4 New: 8

              Unassigned Unassigned
              nroslan Atiqah Roslan
              Votes:
              27 Vote for this issue
              Watchers:
              30 Start watching this issue

                Created:
                Updated: