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
    Commented Feb 23, 2021 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
    Commented Mar 3, 2021 at 12:42
  • I just posted it as an answer below. You can mark that. Thanks :)
    – Jaypan
    Commented Mar 3, 2021 at 17:41

1 Answer 1


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 and acknowledge you have read our privacy policy.

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