UTF8 Character Set, not utf8mb4

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

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

Open Support Ticket

Tagged: UTF8

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

Hurry! Get your 20% discount before it expires. Get 20% Discount