MySQL Collation Problem

  • Resolved mleder

    (@mleder)


    5 years, 2 months ago

    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)

  • Hey @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

    (@mleder)

    Deleted

    • This reply was modified 5 years, 2 months ago by mleder.
    Thread Starter mleder

    (@mleder)

    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 5 years, 2 months ago by mleder.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL Collation Problem’ is closed to new replies.