UTF Collation Types Mixing

  • As a general question, in wp-config, the collation is set to ‘utf8’.
    However, I find that on several sites, the intial install is showing in the db as ‘ut8mb4_unicode_ci’, and a plugin such as wordfence added later shows collation type in the db as ‘utf8_general_ci’.

    Is this type of intermixing problematic? I know that other intermixing types, such as utf8 and latin collations ARE problematic.

Viewing 1 replies (of 1 total)

  • The only problem I know of would be with an older database server that doesn’t support the collation you are trying to migrate into that server. That’s the only collation issue I’ve ever experienced.

    If the database server accepts it then it should be fine. I would keep it in my notes just in case a problem shows up later.

    Is your site having an issue? There is a plugin but I’m not sure if it still works and not sure it would help with anything.

    https://www.ads-software.com/plugins/database-collation-fix/

    A complete backup (files and database) would be in order before you let that run.

    When the collation problem happened to me, the old site was gone and the collation problem wouldn’t let me import the database to the client’s new server so it was a search and replace operation on several chunked database files using Notepad++ to fix that one.

Viewing 1 replies (of 1 total)
  • The topic ‘UTF Collation Types Mixing’ is closed to new replies.