[MDEV-32904] smiley emoji (F09F9883) valid in utf8 but not utf8mb4 - Jira

XML

Word

Printable

Our smiley emoj goes to question mark in utf8mb4 but ok in mb3.

MariaDB [(none)]> select hex('😃'),@@character_set_client;

+----------+------------------------+

| hex('?') | @@character_set_client |

+----------+------------------------+

| 3F       | utf8mb4                |

+----------+------------------------+

1 row in set (0.000 sec)

MariaDB [(none)]> set character_set_client='utf8';

Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> select hex('😃'),@@character_set_client;

+-------------------------+------------------------+

| hex('\xF0\x9F\x98\x83') | @@character_set_client |

+-------------------------+------------------------+

| F09F9883                | utf8                   |

+-------------------------+------------------------+

relates to

MDEV-27490 Allow full utf8mb4 for identifiers

MDEV-11777 REGEXP_REPLACE converts utf8mb4 supplementary characters to '?'

links to

SO original problem

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.