How can I fix the following error I get from a Drupal 7 site?

Incorrect string value: '\xF0\x9F\x92\x99' for column "'comment_body_value'

I read it is about users posting emojis that cannot be handled by Drupal/MySQL.

I don't care if the comments are being stripped off the emojis, or converted as long as it does not trigger an error to the end-user. The simpler the solution the better. I found a few modules, for example the Emoji Scrub module that isn't covered by the security advisory policy.

  • This explains how to solve this issue: jeffgeerling.com/blogs/jeff-geerling/…
    – Jaypan
    Feb 23 at 21:56
  • Thank you Jaypan, I'm happy to see you here. By the way for one reason or another I cannot assign your comment as the answer.
    – MMT
    Mar 3 at 12:42
  • I just posted it as an answer below. You can mark that. Thanks :)
    – Jaypan
    Mar 3 at 17:41

This explains how to solve this issue: https://www.jeffgeerling.com/blogs/jeff-geerling/solving-emoji-problem-drupal-7

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.