Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-11711

Emoji characters causing SQL errors

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Closed
    • Icon: Blocker Blocker
    • 3.1.0-RC2
    • 3.0.12-RC1, 3.1.0-dev
    • Posting
    • None

      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

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

            Marc Marc
            Arty Vjacheslav Trushkin [X] (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: