• Imagegizmo100

    (@gizmo100)


    How can I convert WordPress MySQL tables with collation latin1_swedish_ci to utf8mb4_unicode_520_ci so the data is also converted to the correct format?

Viewing 1 replies (of 1 total)
  • Moderator Imagebcworkz

    (@bcworkz)

    That can all be done through the phpMyAdmin app, usually accessed through your hosting account or cPanel. Changing collation is fairly strait forward. Changing actual character encoding is more involved since it impacts how the data is stored. It’s essential to make a backup before changing actual character encoding. A proper query needs to be run to alter character encoding. There is no UI element to do so.

    You can switch collations through the appropriate UI elements in the app. Be aware that there are several independent collation settings in a DB. The overall DB has one, every table has one, and every textual column in a table has one. You’ll want to change them all. There may be a query that does all of this in one fell swoop, but I don’t know what it’d be.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.