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

    • 8
    • 9
    • 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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-3452 Customer can't raise an issue when he adds an emoji in his text

          • Low - Low priority issues
          • Closed
          is incorporated by

          Suggestion - JRASERVER-36135 Add support for 4 byte characters in MySQL connection

          • Closed
          relates to

          Suggestion - JSDCLOUD-3411 As admin, would like issue creation from email accept email with emoticon

          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:

                Backbone Issue Sync