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

Characters with more than 3 bytes in its default UTF-8

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.2.1
    • None
    • None
    • Windows 10, Apache/2.4.27 (Win64), PHP 5.6.31

    Description

      Hi, 

      If I try add a emoji on Cell Phone or Desktop phpbb trown an error.

      I reproduced this bug on phpbb.com right now.

      It affects almost all text fields. 

      My workaround was add this line

      $query = preg_replace('/[\x{10000}-\x{10FFFF}]/u', '?', $query);

      before 

      $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

      on \phpbb\db\driver\mysql.php

      Please, let me know if you will fix it.

      Thank you in advance.

      Alessandro

      Attachments

        1. Screenshot_2017-07-31-19-59-28.png
          127 kB
          Jonas Machado
        2. Screenshot.jpg
          285 kB
          Jonas Machado

        Issue Links

          Activity

            People

              Unassigned Unassigned
              arbsoft Jonas Machado
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: