UTF8 Character Set, not utf8mb4

This topic contains 4 replies, has 3 voices, and was last updated by  Paolo 9 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: 

  • Author
    Posts
  • August 15, 2015 at 9:40 pm #49590

    Vi Wickam
    Expired Member
    Post count: 29

    Hi,

    I am trying to migrate a site to a new server, and have encountered a character set mismatch.

    It looks like everything in the database except the WPGEODIRECTORY tables is set to the WordPress default character set, UTF8 (utf8_general_ci). WPGEODIRECTORY tables are set to utf8mb4.

    https://codex.wordpress.org/Converting_Database_Character_Sets

    What are the implications, if any, of converting the WPGEODIRECTORY tables to UTF8?

    August 16, 2015 at 1:50 am #49602

    Guust
    Moderator
    Post count: 29970

    Hi Mike, I escalated your question.

    August 17, 2015 at 3:40 pm #49735

    Vi Wickam
    Expired Member
    Post count: 29

    Hi,

    Looks like I was wrong … utf8mb4 IS the new WordPress default character set, as of WordPress version 4.2.

    Still, my question remains: what happens – if anything – if I were to convert the WPGEODIRECTORY tables to UTF8?

    August 17, 2015 at 4:11 pm #49743

    Paolo
    Site Admin
    Post count: 31206

    Hi Mike,

    unless 4.2 added something else that I’m unaware of, it should be totally fine to change database collation to UTF8.

    Let us know,

    Thanks

    August 17, 2015 at 4:14 pm #49745

    Paolo
    Site Admin
    Post count: 31206

    For more info: https://wordpress.org/support/topic/different-collation-in-db-after-upgrade-to-421

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount