[PHPBB3-15299] Characters with more than 3 bytes in its default UTF-8

XML

Word

Printable

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

duplicates

PHPBB3-15712 Inserting an emoji in PM subject field causes errors

is related to

PHPBB3-15712 Inserting an emoji in PM subject field causes errors