Using Emoji with phpList

It is possible to convert a phplist installation already installed to “emoji” capable by doing the following:

  1. change the mysqli.inc to refer to “utf8mb4” in every references to “utf8” (set names, charater set
  2. execute the change on database utf8mb4
  3. execute the change on the tables: config, template, message, messagedata, event_log
  4. optionally other tables can be changed: user_user_history, subscribepage, subscribepage_data, i18n

To change database codification method:

ALTER DATABASE
    database_name
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

To change tables codification method:

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`

For more information about this topic:

As always, be aware that you should make backups prior to any commands that make this kind of change on the database.

1 Like