Support » Fixing WordPress » Changin MySQL connection collation

  • Resolved ucarmetin



    I’m about to migrate one of my wordpress sites to another server. I’m doing database backup but apparently due to the default mysql connection collation is set to utf8_unicode_ci and I need to export the database in utf8_swedish_ci, I have some problems with displaying special swedish characters. My hosting provider doesn’t provide me means to perform exporting via mysql commands. Therefore I have to change the mysql connection collation of the database I want to export via phpmyadmin ‘s operations section. I’m about to perform the change but first I would like to make sure two things as the database I’m going to perform changes on is a magazine website’s database and a mistake during the process could cause a big trouble for me. So, here are the two points I want to make sure:

    1) If I change the mysql connection collation, will that truly affect the existing database? I’m asking this because I’ve followed some short tutorials on this manner and when I performed the changes based on these instructions, only new table’s mysql connection collation changes.

    2) Could changing mysql connection collation from utf8_unicode_ci to utf8_swedish_ci via phpmyadmin’s operations panel cause any problem with the existing content of the site?

    Thanks a lot in advance.
    Every piece of information and help is truly appreciated.

  • The topic ‘Changin MySQL connection collation’ is closed to new replies.