Title: Database collation
Last modified: February 27, 2017

---

# Database collation

 *  [catalaco](https://wordpress.org/support/users/catalaco/)
 * (@catalaco)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-2/)
 * I installed iThemes Security on the developement site. Now I’m trying to copy
   the changed WordPress site back to the live site but I get the error message:“
   Unknown collation: utf8mb4_unicode_520_ci”
    (I have mysql v15 on the dev site
   and v14 on the live site)
 * The 3 “wp_itsec” tables are the only ones to use this collation, thus preventing
   me to go live with my changes… How can I fix this issue without deleting and 
   reinstalling the plugin on the live site (it took me forever to configure iThemes!)
   
   Thanks for your help!

Viewing 1 replies (of 1 total)

 *  Thread Starter [catalaco](https://wordpress.org/support/users/catalaco/)
 * (@catalaco)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-2/#post-8855095)
 * Well I changed the collation manually and it worked… I was afraid it would create
   errors.

Viewing 1 replies (of 1 total)

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

 * ![](https://ps.w.org/better-wp-security/assets/icon.svg?rev=3529351)
 * [Kadence Security – Password, Two Factor Authentication, and Brute Force Protection](https://wordpress.org/plugins/better-wp-security/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-wp-security/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-wp-security/)
 * [Active Topics](https://wordpress.org/support/plugin/better-wp-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-wp-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-wp-security/reviews/)

## Tags

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

 * 1 reply
 * 1 participant
 * Last reply from: [catalaco](https://wordpress.org/support/users/catalaco/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-2/#post-8855095)
 * Status: not resolved