pootle discards developer comments that contain 4-byte UTF-8 characters (was: templates updated in master projects (for 5.0 release))

l10n
#1

Hi *,

<lohmaier+ooofuture@googlemail.com>:

But just noticed a bug in pootle. It doesn't display the developer
comments for the higher unicode samples...

Must be unicode related bug in the DB....

https://translations.documentfoundation.org/ru/libo_ui/translate/extras/source/autocorr/emoji.po#filter=all&unit=93425565

#. 𝄞 (U+1D11E), see http://wiki.documentfoundation.org/Emoji
#. 6CVtL
#: emoji.ulf

This is https://code.djangoproject.com/ticket/13919 - or more precise
mysql only able to store three-byte utf8 encodings - the ones like
clef symbol and others require four bytes in utf8.
Unfortunately in this case the whole comment is discarded and not stored.

we have mysql 5.5 running on the server, so we might switch to the
extended character type for the comments

http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

But I'd rather wait for Dwayne's comment on that (as this might affect
upgrades or other scripts)

ciao
Christian