Wordfence don’t support utf8mb4 character set

  • I use MySql 8.0.14 with WordPress.
    Character set utf8 (utf8mb3) has been deprecated since MySql 8.0.13 and will be removed in a future release.

    Wordfence is the only plugin I use that, even in completely new installation, keep creating all the tables and data with utf8mb3 and collation utf8_general_ci

    Please update Wordfence to use utf8mb4 for new installation. You should use utf8mb4 that is the new utf8

    • This topic was modified 6 years, 1 month ago by efilippucci.
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @efilippucci,

    Wordfence creates tables using CHARSET=utf8 (looking at wordfence/lib/wfSchema.php).

    As per the documentation:

    Although utf8 is currently an alias for utf8mb3, at that point utf8 will become a reference to utf8mb4.

    https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html

    This means that eventually when utf8mb3 is deprecated, utf8 will reference the new charset.

    We will be keeping our usage of utf8 to be backwards compatible with utf8mb3 and utf8mb4.

    I’ll ask the team for more information regarding this, and I’ll get back to you as soon as I can!

    Dave

    Thread Starter efilippucci

    (@efilippucci)

    Hi Dave,
    for your information, utf8mb3 is much slower then utf8mb4 in MySQL 8.0.

    I have removed all the utf8mb3 from my sites since I think it is dangerous to keep data in utf8mb3 and upgrade to newer MySQL 8.0 version.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Wordfence don’t support utf8mb4 character set’ is closed to new replies.