Title: Database collation error
Last modified: March 16, 2017

---

# Database collation error

 *  [jhtjards](https://wordpress.org/support/users/jhtjards/)
 * (@jhtjards)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-collation-error-2/)
 * Hi, after installing your plugin I get the following error on the product single
   page just above the variation select fields. (Not showing any swatches in the
   frontend)
    I haven’t had this error before so I assume it’s a bug in the plugin.
 * `WordPress-database-error: [Illegal mix of collations (utf8_general_ci,IMPLICIT)
   and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=']`

The topic ‘Database collation error’ is closed to new replies.

 * ![](https://ps.w.org/variation-swatches-for-woocommerce/assets/icon-256x256.png?
   rev=2602534)
 * [Variation Swatches for WooCommerce](https://wordpress.org/plugins/variation-swatches-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/variation-swatches-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/variation-swatches-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/variation-swatches-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/variation-swatches-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/variation-swatches-for-woocommerce/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [jhtjards](https://wordpress.org/support/users/jhtjards/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/database-collation-error-2/)
 * Status: not resolved