Forum GLPI-Project

sebastian

Member

Registered: 2016-07-29

Posts: 9

Emojis cutting off Texts

Hello,

when I create or update a ticket text, it will cut after the use of Unicode Emojis.
For example: "Hello there ? this is a test message" will cut after "Hello" and  not save the rest of the text.

This happens for both, tickets coming via email and tickets created via WebUI

This problem occurs quite often because outlook automatically coverts Strings like ":-)" to Unicode emojis......

PHP and MySQL is both set to UTF8.
Can someone help? Unfortunately nothing in GLPI logfiles... :-(

Sebastian

sebastian

Member

Registered: 2016-07-29

Posts: 9

Re: Emojis cutting off Texts

Ok, got it fixed.

Solution:
- Upgrade to MySQL 5.7
- Change Server Charset to utf8mb4
- Change all Tables Charset to utf8mb4
- Replace all "utf8" with "utf8mb4" in inc/dbmysql.class.php

Bye
Sebastian