Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-11711

Emoji characters causing SQL errors

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Closed
    • Affects Version/s: 3.0.12-RC1, 3.1.0-dev
    • Fix Version/s: 3.1.0-RC2
    • Component/s: Posting
    • Labels:
      None

      Description

      When using emoji characters in post or topic title, it causes SQL errors. Probably affects other parts as well.

      Example character: (cannot post, caused crash in Jira!!!)

      SQL error: 

      SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9F\x8E\xAF' for column 'topic_title' at row 1 [1366]

      See http://en.wikipedia.org/wiki/Emoji

        Attachments

        1. image1.jpg
          image1.jpg
          135 kB
        2. image2.jpg
          image2.jpg
          130 kB

          Issue Links

          caused

          Improvement - An improvement or enhancement to an existing feature or task. PHPBB3-13178 Allow posting Emoji characters if the database supports it

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-9971 phpbb crashes when posting a 4 byte character with MySQL before 5.5.3

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-11514 SQL ERROR [ mysql4 ] Incorrect string value: '\xF0\xA6

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-11820 CLONE - 4-bytes encoded UTF-8 chars issue

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. PHPBB3-12745 Allow Emoji characters in posts

          • Major - Major loss of function.
          • Unverified Fix

            Activity

              People

              • Assignee:
                Marc Marc
                Reporter:
                Arty Vjacheslav Trushkin
              • Votes:
                1 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: