It is possible to convert a phplist installation already installed to “emoji” capable by doing the following:
- change the mysqli.inc to refer to “utf8mb4” in every references to “utf8” (set names, charater set
- execute the change on database utf8mb4
- execute the change on the tables: config, template, message, messagedata, event_log
- 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.