Title: WordPress database error: Character set ‘binary’ cannot be used
Last modified: June 28, 2023

---

# WordPress database error: Character set ‘binary’ cannot be used

 *  Resolved [buckrackley](https://wordpress.org/support/users/buckrackley/)
 * (@buckrackley)
 * [2 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-character-set-binary-cannot-be-used/)
 * Hello! First off, thank you. I love your work.
 * I’m getting an error across the top of any admin page:
 * **WordPress database error:** [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_template' AND BINARY ``meta_key` REGEXP '_sked_[A-Z].+' 
   and meta_value AND post_status='publish' GROUP BY wp_posts.ID ORDER BY post_title
 * On the user side, any page that has RSVPmaker components displays as a blank 
   page. Which is kinda scary cause it’s the whole events section.
 * I didn’t make any changes on my end. This message and behavior was there when
   I logged in today, after a few days of inactivity.
 * Do you have any suggestions I could try?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [davidfcarr](https://wordpress.org/support/users/davidfcarr/)
 * (@davidfcarr)
 * [2 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-character-set-binary-cannot-be-used/#post-16856221)
 * I just put out an update that removes that binary keyword from the sql code, 
   as the reason for it is obsolete. Let me know if installing that solves the issue.
 *  Thread Starter [buckrackley](https://wordpress.org/support/users/buckrackley/)
 * (@buckrackley)
 * [2 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-character-set-binary-cannot-be-used/#post-16856324)
 * Solved it! Thank you so much!!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database error: Character set ‘binary’ cannot be used’ 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/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 2 replies
 * 2 participants
 * Last reply from: [buckrackley](https://wordpress.org/support/users/buckrackley/)
 * Last activity: [2 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-character-set-binary-cannot-be-used/#post-16856324)
 * Status: resolved