Changing tables collation to all the same?

  • Resolved squeebo

    (@squeebo)


    3 years, 3 months ago

    My db tables are all innodb type. Collation is mixed: Core and some plugins are utf8mb4_unicode_ci, other plugins are utf8_general_ci, latin1_swedish_ci, or utf8_unicode_ci.

    Is it advisable to change all table collations to something uniform for performance or other reasons?

    If it matters, it’s a US English only site, on a VPS that is kept updated.

    • This topic was modified 3 years, 3 months ago by Jan Dembowski.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    Ideally everything would be some variant of utf8mb4. If all text data is solely composed of the English alphabet, the varied collations should’t have any impact. It’s in the extended characters where things really make a difference. But then with only English text, you’re least likely to encounter difficulties by altering collations. I recommend at least changing the Swedish collation. You may change others as well. Be advised that it’s possible to have different collation settings for not only for each table, but also for the entire DB and individual columns as well. If you’re going to make everything consistent, be thorough at it ?? Don’t forget there’s a DB collation definition in wp-config.php. This may be left as an empty string, but you could set it to the collation used if they’re all the same.

    While changing collations shouldn’t cause any problems, please make a full DB backup before doing so anyway. Better safe than sorry.

    Thread Starter squeebo

    (@squeebo)

    Ok, thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Changing tables collation to all the same?’ is closed to new replies.