Details
-
Bug
-
Resolution: Solved By
-
Major
-
None
-
8.0
-
MySQL
-
Unknown
-
N/A
-
N/A
-
Description
Summary:
On an XWiki installation that uses MySQL, emoji characters render as question marks.
Steps to Reproduce:
- Setup XWiki with MySQL as the database
- Create a wiki page with some emoji characters
- View the page
Expected Result:
The emoji should render correctly
Actual Result:
The emoji characters renders as question marks.
Is this a Regression?
No, this is not a regression and appears to be an underlying issue with XWiki + MySQL
Notes:
- This is caused by MySQL's default encoding (in XWiki) which is "utf8" and not "utf8mb4" (4-byte UTF to store the full unicode character set).
- Changing XWiki's default data encoding for MySQL to be "utf8mb4" should fix the issue.
Attachments
Issue Links
- depends on
-
XWIKI-15215 XWiki 10.3 fails to start on MySQL with utf8mb4 encoding
- Closed
-
XWIKI-16264 Use main wiki encoding/collation when creating a subwiki database on MySQL
- Closed
- is duplicated by
-
XWIKI-17035 Can't save a page that contains Emoji on MySQL 5.7
- Closed