Support » Fixing WordPress » Character encoding nigthmare

  • I had it comming! I used character encoding ISO 8859-1 (portugal)
    in WP 1.2. I´ve tried to move to UTF-8 with WP 1.5.3 but i´ve make a very, very, big mistake: accidently set UNICODE-1-1-UTF-7 !

    Now WP options does not allow anything to change back from UNICODE-1-1-UTF-7!!!
    Is it a browser probleam (firefox), do I need to change a file
    or do i have to delete my blog database (snif)?

    Please help!!!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator James Huff


    Volunteer Moderator 🚀

    No, no, you don’t have to delete your database. Just access your database via phpmyadmin and go to the “wp_options” table. Now, look for the option named “blog_charset” and choose to edit it (usually a pencil-like icon to the right of the line). In the “option_value” field, enter “utf-8” (without the quotes, of course).

    After you’ll succeed to do what macmanx described above, you will realize that all your posts are screwed up… the special (accented) characters typed in iso-8859-1 will look ugly in utf-8 🙂

    Moderator James Huff


    Volunteer Moderator 🚀

    Yes, as with any character encoding switch, there will be some post-conversion editing involved. That’s when the true nightmare begins.

    The PhpMyAdmin did the trick but was a little esoteric! 🙂
    As someone has an idea how to force a MySQL database from ISO 8859-1 to utf-8?
    I´ve rolled back to 1.2 because i can´t make a decent localization as i had before, and if i don´t swich to utf-8 the templates get all mess up.
    Thanks for your help!

    See this topic:

    Tried that topic solotion ( – change from ISO-8859-15 to UTF-8), but UltraEdit didn´t noting, it saved files as dos-8 and the ISO-8859-1 caracters apeared like a mess in the UTF-8 form.
    Is there other windows aplication to try this again?

    navengate: I gather you have solved the editor problem by now, but for someone else: Nowadays even Notepad can save to UTF-8, but I would rather use TextPad. It will automaticaly recognize the encoding when reading a file. It also has a nice set of options you can set as per document type, and you’re a programmer, you’ll get color coded source for a lot of document types – more coming by plugins.
    I used it for Java coding and could even compile/run from within Textpad.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Character encoding nigthmare’ is closed to new replies.