Emoji support and MariaDB 10.0.30

  • I am using WordPress 4.7.3 with the built in Emojii support. We have recently moved to MariaDB 10.0.30, but the original wp-config indicates

    define('DB_CHARSET', 'utf8).

    I have noticed that I cannot use emojis and, for example, if I try to include an emoji as category and have enabled the debug mode, I am returned with this:

        WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=']
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND t.name IN (':smile:') ORDER BY t.name ASC

    How difficult is to make my Db “emoji compatible”? I am not comfortable with altering the Database character sets as described here: https://codex.www.ads-software.com/Converting_Database_Character_Sets and I wonder whether there is any other alternative.

    Thank you,

    Regards

  • The topic ‘Emoji support and MariaDB 10.0.30’ is closed to new replies.