You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-03-20 14:43:13

sebastian
Guest
Registered: 2016-07-29
Posts: 7

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

Offline

#2 2018-06-26 11:23:34

sebastian
Guest
Registered: 2016-07-29
Posts: 7

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

Offline

Board footer

Powered by FluxBB