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

Hi *,

On Mon, Jun 29, 2015 at 3:08 PM, Christian Lohmaier
<lohmaier+ooofuture@googlemail.com> wrote:
> On Mon, Jun 29, 2015 at 3:02 PM, Serg Bormant <bormant@gmail.com> wrote:
> > 2015-06-29 15:37 GMT+03:00 Christian Lohmaier
> > <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

-- 
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted