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

            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: