Dotclear

Vous n'êtes pas identifié(e).

Annonce

13 février 2024 Sortie de Dotclear 2.29

#1 2021-07-07 03:05:57

Ian_R
Membre
Inscription : 2021-07-07

Emoji from IOS causes post to truncate and makes editing impossible

I'm using Version 2.18.1 hosted by Bluehost I am using the dcCKEditor plugin.

What I did to cause the issue:

I inserted a smilie face emoji from IOS while editing the CONTENT section of a post on an iPad.

Before I saved the post the emoji was visible in the editor.

After I saved the post, the following happened:

1. All text and images in the post from the insertion point of the emoji including the emoji were not visible
2. I was unable to view any of the source code for the content section of that post
3. Any changes made to the content section of the post that I could see (i.e. before the emoji insertion point) are not saved.
4. I can edit and save the Excerpt section of the post

The only solution I had was to recreate the post and put a redirect in the corrupted post.

Thanks,

ian

Hors ligne

#2 2021-07-07 09:21:06

Franck
Footer de merde
Lieu : Paris
Inscription : 2004-11-09
Site Web

Re : Emoji from IOS causes post to truncate and makes editing impossible

Hi,

Are you using a UTF8 database or a UTF8-mb4 one? In the first case some emojis, which may be encoded on 4 bytes, cannot be handled by a UTF8 database (the limit is 3 bytes for encoded characters).

To bypass this limitation you can install this plugin: https://plugins.dotaddict.org/dc2/details/utf8mb4, it may help.

Let us know


Dotclear addicted since 2004

Hors ligne

#3 2021-07-08 12:58:52

Ian_R
Membre
Inscription : 2021-07-07

Re : Emoji from IOS causes post to truncate and makes editing impossible

Hi Franck,

From the MyPhPadmin page it says that server collation is UTF8mb4_unicode_ci. In the character set page of  MyPHPadmin it shows both selected UTF8 and UTF8mb4 selected.

Is there a MySQL tool or utility to clean the table of inappropriate characters perhaps?

Thanks,

Ian

Dernière modification par Ian_R (2021-07-08 13:00:29)

Hors ligne

#4 2021-07-11 07:11:16

Franck
Footer de merde
Lieu : Paris
Inscription : 2004-11-09
Site Web

Re : Emoji from IOS causes post to truncate and makes editing impossible

Ok so it's may be not an UTF8 encoding problem, very weird!

Note that server collation is not database collation, may be you should try to install the plugin and see what happens?


Dotclear addicted since 2004

Hors ligne

Vous n'êtes pas identifié(e).

Pied de page des forums

Sites map