Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter brunotorres

    (@brunotorres)

    Well, instead of using phpmyadmin, I imported the database from the ssh shell, using:
    mysql -u user -p -h host < databasefile.sql
    The file was created from an export operation on phpmyadmin and was saved as utf-8.
    It just worked. At least so far.
    If I find any other problem or the definite solution to this, I’ll post here again.
    Thanks a lot for the time you took to help me!
    Cheers!

    Thread Starter brunotorres

    (@brunotorres)

    Yes, I found this. But, changing or not changing, I get to the same problem.
    See, if I write a post from the wp admin interface, all the special characters appear well on the weblog. But they appear as weird symbols on phpmyadmin. Even if I use UTF-8 or ISO-8859-1.
    I can import my database as ISO or as UTF-8 and it only works as ISO. It only works as UTF-8 if I post from the user interface.
    Since, I’m migrating and have a bunch of posts written, I’m not supposed to post all of them from the admin interface. Or am I?
    It is a really weird thing. There must be a solution to this and, please, don’t get me wrong but I have made lots of searches on this subject.
    And I don’t want to use ISO-8859-1. So, anyone has a real solution to this?
    Thanks.

    Thread Starter brunotorres

    (@brunotorres)

    I have searched for it, but none of the answers helped me.
    Look, I edit a database in utf-8 and it only works as iso-8859-1. It’s too weird.
    I tried to use utf8_general_ci collation, but it didn’t work.
    There has to be an answer to this…
    Thanks, anyway.

Viewing 3 replies - 1 through 3 (of 3 total)