Title: MySQL Collation Problem
Last modified: January 11, 2020

---

# MySQL Collation Problem

 *  Resolved [mleder](https://wordpress.org/support/users/mleder/)
 * (@mleder)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/mysql-collation-problem/)
 * Been reviewing db tables for several sites using WF Free. These sites were all
   created within the last 2-3 years. We had set collation during initial setup 
   as UTF-8 (in wp-config). Most of the WF tables are collated using this. However,
   to my suprise, three WF tables in each of these sites are collated using latin1_swedish_ci.
 * Why does this happen, and should I be concerned?
 * BTW: In each of the db’s, the three tables in question are wfCrawlers, wfHits,
   and wfReverseCache.

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

 *  [WFGerroald](https://wordpress.org/support/users/wfgerald/)
 * (@wfgerald)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/mysql-collation-problem/#post-12338353)
 * Hey [@mleder](https://wordpress.org/support/users/mleder/),
 * The old tables have Latin collation. When we add new ones we use utf8. So the
   Latin is only there for backward compatibility. But just to be clear, this isn’t
   something you should worry about.
 * Please let me know if you have any other questions.
 * Thanks,
 * Gerroald
 *  Thread Starter [mleder](https://wordpress.org/support/users/mleder/)
 * (@mleder)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/mysql-collation-problem/#post-12338366)
 * Deleted
    -  This reply was modified 6 years, 4 months ago by [mleder](https://wordpress.org/support/users/mleder/).
 *  Thread Starter [mleder](https://wordpress.org/support/users/mleder/)
 * (@mleder)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/mysql-collation-problem/#post-12338369)
 * FYI – for the WF tables, I was able to correct the problem by setting a parameter
   to delete WF files, then deactivating WF, then reactivating, finally reset the
   parameters. My reply above did not pertain to WF specifically, sorry.
    -  This reply was modified 6 years, 4 months ago by [mleder](https://wordpress.org/support/users/mleder/).

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

The topic ‘MySQL Collation Problem’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [mleder](https://wordpress.org/support/users/mleder/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/mysql-collation-problem/#post-12338369)
 * Status: resolved