[wp-trac] [WordPress Trac] #46947: ‘❤’ in Comment Generates DB Error

[WordPress Trac]

#46947: ‘❤’ in Comment Generates DB Error
--------------------------------+-----------------------------
 Reporter:  HisKingdomProphecy  |      Owner:  (none)
     Type:  defect (bug)        |     Status:  new
 Priority:  normal              |  Milestone:  Awaiting Review
Component:  General             |    Version:  5.1.1
 Severity:  normal              |   Keywords:  needs-testing
  Focuses:                      |
--------------------------------+-----------------------------
 I got the following error message notice when a post comment included the
 ‘’ special character.
 When I approved the comment, there was no further error message generated.
 I have not seen this message before – but then again, we rarely get
 special character in comments.
 I am using WordPress 5.1.1. The WP-config: ‘define(‘DB_CHARSET’, ‘utf8′);’
 Can someone please advise how to fix this?

 Regards and thanks,
 Angus

 Error message:
 *** [Thu Mar 21 02:17:57.574584 2019] [php7:notice] [pid 24789] [client
 68.40.22.245:41759] WordPress database error Illegal mix of collations
 (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for
 operation ‘=’ for query SELECT comment_ID FROM xxxcomments WHERE
 comment_post_ID = 134978 AND comment_parent = ‘0’ AND comment_approved !=
 ‘trash’ AND ( comment_author = ‘Rhonda Lott’ AND comment_author_email =
 ‘xxx at yahoo.com’ ) AND comment_content = ‘Amen And Amen! Thank you
 Rabbi!\xe2\x9d\xa4\xf0\x9f\x94\xa5\xf0\x9f\x92\xaf\xf0\x9f\x99\x8c’ LIMIT
 1 made by wp_handle_comment_submission, wp_new_comment, wp_allow_comment,
 referer: https://www.hiskingdomprophecy.com/its-time-to-unearth-the-truth/
 ***

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/46947>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform