• Resolved Stefano Lissa

    (@satollo)


    Hi, thank you for your cool plugin.

    When the plugin tries to log emails containing utf-8 characters which need 4 or more bytes to be encoded, it can fail, since the table is created using the utf8 charset and not the utf8mb4.

    I can suggest in the “create” statement to use the global variable $charset_collate, provided by WP which contains the query part with the right charset and collation.

    As example:

    $sql = "CREATE TABLE... 
      id int(11) NOT NULL AUTO_INCREMENT,
      ...
      PRIMARY KEY (id)
    ) $charset_collate;";
    

    Once changed, in my database, the logging started to work (I have mails with emoji coded in utf-8).

    Stefano.

Viewing 1 replies (of 1 total)
  • Plugin Support Dake

    (@dakeg)

    Hi @satollo

    Thank you very much for bringing this to our attention and we apologize for the delay and any inconvenience caused by this issue.

    Our developers have been informed about this issue and your suggestion.

    We don’t have a timeline for when this will be tested and implemented, but if and when it does it will be listed in our change log.

    Thanks again ??

Viewing 1 replies (of 1 total)
  • The topic ‘Change table charset’ is closed to new replies.