Some Emojis Not Showing

  • Resolved Furkan ?zden

    (@furkanozden)


    1 year, 6 months ago

    Hello,

    Some of the emojis I try to use in my posts are not visible. I add emojis with “Start + .” shortcut. But some ???? appears in the form.

    For example:

    Content that I wrote and also saw in this post editor.

    ???????????????????????

    These are the text previews and the ones I saw in the final version.

    ?????????????????????????????????????????

    As you can see, some appear and some do not.

    What I’ve tried so far:
    Adding the tweemoji script between the <head> tags.
    Disabling the cache plugin.

    Some information you should know:
WP Version: 6.2.2
HTTPS: yes
PHP: 7.4.33 (64Bit Supported)
Server architecture: Linux 3.10.0-962.3.2.lve1.5.66.el7.x86_64 x86_64
Web server: LiteSpeed
PHP: max input variables 5000
PHP time limit: 300
PHP memory limit: 2048M
Maximum login time: 300
Maximum file upload size: 128M
PHP maximum send size: 128M
cURL version: 7.87.0 OpenSSL/1.1.1p
Database
Extension: mysqli
Server version: 10.3.38-MariaDB-cll-lve
    • This topic was modified 1 year, 6 months ago by Furkan ?zden.
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi there,

    the problem is most likely the collation of your MySQL database. I am pretty sure it is just “utf8” and it needs to be utf8mb4. See also this core post from 2015.

    The reason that some emoji characters that you shared work is caused by what byte sequences represent them:

    U+1F64C PERSON RAISING BOTH HANDS IN CELEBRATION character: ??
U+1F612 UNAMUSED FACE character: ??
U+26D4 NO ENTRY character: ?
U+1F44D THUMBS UP SIGN character: ??
U+1F381 WRAPPED PRESENT character: ??
U+1F4CB CLIPBOARD character: ??
U+1F986 DUCK character: ??
U+1F440 EYES character: ??
U+1F501 CLOCKWISE RIGHTWARDS AND LEFTWARDS OPEN CIRCLE ARROWS character: ??
U+274C CROSS MARK character: ?
U+2757 HEAVY EXCLAMATION MARK SYMBOL character: ?
U+2728 SPARKLES character: ?
U+270D WRITING HAND character: ?
U+1F4CC PUSHPIN character: ??

    As you can see, all the emojis that worked start with U+26/7 and those that don’t with U+1F and are 1 byte longer.

    Changing the MySQL collation can be done in a tool like phpMyAdmin or with a dedicated plugin. I recommend you to look at this guide by Florian Brinkmann on how to Switch WordPress from utf8 to utf8mb4 retrospectively.

    Thread Starter Furkan ?zden

    (@furkanozden)

    Thank you very much for your detailed and descriptive comment. But I’m afraid of doing permanent damage if I change the database’s code set. So I’m going to take a backup and try this method over the weekend. Thanks again.

    Kind regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Some Emojis Not Showing’ is closed to new replies.

Tags