Text strings with emoticons

Re: Text strings with emoticons

дэргэд koen roggemans -
Хариу нийтлэлийн тоо: 2
Language pack maintainers зураг

It should work if you use UTF-8 emoticons and if the database is converted to support 4 byte unicode.

4 byte support  was part of an upgrade some time ago ... See https://docs.moodle.org/400/en/MySQL_full_unicode_support

Unicode emojis are (i think) these ones: https://www.w3schools.com/charsets/ref_emoji.asp

koen roggemans-н хариуд

Re: Text strings with emoticons

дэргэд Ralf Krause -
Language pack maintainers зураг

Thank you, Koen.

We are translating the language packs for all Moodle platforms ... so we must see all platforms in the world. 

What happens with a text string if the text string comes with an emoticon and the Moodle database runs with utf8_general_ci and not with utf8mb4_general_ci? Will Moodle use the text string? Can Moodle provide the text string with the emoticon or will Moodle get problems with this text string?

Best regards, Ralf

Ralf Krause-н хариуд

Re: Text strings with emoticons

дэргэд koen roggemans -
Language pack maintainers зураг
I don't know what the effect is of using a 4-byte language pack on a not migrated database. I think no problem as long as no 4 byte utf-8 characters are written to it. But that is hard to predict if and when that will happen. There are also loads of other easy ways users can enter 4 byte characters in the database, e.g. making a forum post from a mobile phone and adding an emoticon.

So, honestly, I don't think it is an issue. The feature of being able to use 4byte utf-8 characters went in on 13 March 2017. There are reminders on the upgrade page that converting the database is necessary. That is over 5 years now. No one should run a web app for 5 years without upgrading it or should ignore the upgrade recommendations. Newer installations should follow the installation guide and have 4-byte support.