search

phpList / phplist3

Fully functional Open Source email marketing manager for creating, sending, integrating, and analysing email campaigns and newsletters.
https://www.phplist.org
GNU Affero General Public License v3.0
734 stars 268 forks source link

Emoji in subject lines #1000

Closed utagawal closed 6 months ago

utagawal commented 8 months ago

Refering to this report it would be nice to have the behavior by default : https://discuss.phplist.org/t/emoji-in-subject-line/8772

With version 3.6.14 there is now a Database error 1366 while doing query Incorrect string value: '\xF0\x9F\x94\xA7 e...' for column phplist.phplist_messagedata.data at row 1

when trying to send a campaign containing a subject with emojis "3437 🔧 et rouler de nuit 🌛"

Database collation is utf8mb4_general_ci

Used to work with phplist 3.6.12

michield commented 6 months ago

Yes, that's being discussed in #978