Change collation GD tables

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

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

Open Support Ticket

Tagged: collation

Author

Posts
January 25, 2017 at 3:13 pm #349285

Paolo
Expired Member

Post count: 7

Hello!
I have a problem to duplicate posts with WPML.
The WPML support say me to change the collation of the GD tables, from utf8mb4_unicode_520_ci to utf8mb4_unicode_ci (the same collation of wp_posts table and wp_icl tables).
I would like to know if there are some problems to do it or if the collation change is indifferent.
Thanks.
Paolo

January 25, 2017 at 7:29 pm #349491

Paolo
Site Admin

Post count: 31211

Hi,

it shouldn’t be a problem at all. It’d be actually strange that the collation of our tables is different from the rest of the DB…

Thanks

January 25, 2017 at 7:30 pm #349492

Paolo
Site Admin

Post count: 31211

p.s. making a backup is always a good idea before performing any change on the DB. 🙂

January 26, 2017 at 2:04 pm #349813

Paolo
Expired Member

Post count: 7

Hi,
changed the collation!
Zero problems and now it works perfectly with WPML!
Thanks.
Paolo

January 26, 2017 at 2:45 pm #349829

Paolo
Site Admin

Post count: 31211

You are welcome 🙂
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