Character encoding nigthmare (8 posts)

  1. navegante
    Posted 11 years ago #

    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!!!

  2. James Huff
    Support Team Rep.
    Posted 11 years ago #

    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).

  3. moshu
    Posted 11 years ago #

    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 :)

  4. James Huff
    Support Team Rep.
    Posted 11 years ago #

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

  5. navegante
    Posted 11 years ago #

    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!

  6. moshu
    Posted 11 years ago #

    See this topic:

  7. navegante
    Posted 11 years ago #

    Tried that topic solotion (wordpress.org/support/topic/20807 - 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?

  8. petit
    Posted 10 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic