Support » Fixing WordPress » Mysql collation

  • In phymyadmin, when it displays the db files, under “collation” it says: latin1_swedish_ci

    Is this correct?

    The first move to a new domain was unsuccessful and I will try it again. I did edit the sql file in notepad changing the domain name etc. but didn’t notice the “collation” language before.


Viewing 4 replies - 1 through 4 (of 4 total)
  • Mark (podz)


    Support Maven

    Don’t worry about it – it’s wierd but not a problem at all.
    If you do hit any errors, just post back here 🙂

    Ok thanks podz, I’ll try it again and ignore that language thing.

    Ok, it worked great this time. I found for some reason, when I try to browse and upload the sql file in phpmyadmin, it doesn’t work, I get a error message.

    When I copy and paste the sql file into the box, it works fine.

    Thanks podz.

    i got a problem…
    when i moved my DB and it says latin1_swedish_ci, the accents looks like werid charcters on the blog (reading options is set to UTF-8) and in the database. i changed collation to utf8_spanish2_ci and now the accents look ok in the DB but changed while reading the blog. i tried putting “utf8_spanish2_ci” in the options for reading, but still getting “?” signs instead of “á é ó ¿” chars…
    any idea?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Mysql collation’ is closed to new replies.