Title: SQL error in Admin: Character set ‘binary’ cannot be used with ‘u
Last modified: October 21, 2021

---

# SQL error in Admin: Character set ‘binary’ cannot be used with ‘u

 *  [mwenell](https://wordpress.org/support/users/mwenell/)
 * (@mwenell)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/sql-error-in-admin-character-set-binary-cannot-be-used-with-u/)
 * Admin gives database error messages below:
 * [Character set ‘binary’ cannot be used in conjunction with ‘utf8mb4_unicode_520_ci’
   in call to regexp_like.]
    SELECT wp_posts.*, meta_value as sked FROM wp_posts
   JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE post_type=’rsvpmaker’
   AND BINARY `meta_key` REGEXP ‘_sked_[A-Z].+’ and meta_value AND post_status=’
   publish’ GROUP BY wp_posts.ID ORDER BY post_title
 * at
 * /wp-admin/edit.php?post_type=rsvpmaker&page=rsvpmaker_template_list

The topic ‘SQL error in Admin: Character set ‘binary’ cannot be used with ‘u’ is
closed to new replies.

 * ![](https://ps.w.org/rsvpmaker/assets/icon-128x128.png?rev=1050978)
 * [RSVPMaker](https://wordpress.org/plugins/rsvpmaker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rsvpmaker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rsvpmaker/)
 * [Active Topics](https://wordpress.org/support/plugin/rsvpmaker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rsvpmaker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rsvpmaker/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [mwenell](https://wordpress.org/support/users/mwenell/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/sql-error-in-admin-character-set-binary-cannot-be-used-with-u/)
 * Status: not resolved