WordPress.org

Forums

character set problems (7 posts)

  1. coverlim
    Member
    Posted 9 years ago #

    i am migrating a wordpress blog, and i moved the DB from 4.1 -> 4.1 mysql, with collated character set latin1_swedish_ci. i moved the db with the export function in phpmyadmin, and loaded it using the mysql prompt. i also tried exporting in MYSQL40 compatability.

    the new site is showing some wierd characters. the code, headers, etc are all the same as the original site (UTF-8)

    but the original site displays the characters perfectly.

    any ideas?

  2. jumbo
    Member
    Posted 9 years ago #

    Did you move the site to another server as well. If so, and you're on apache, the 'AddDefaultCharset' httpd.conf directive may be set to something which is causing problems for you. For instance, I had to change 'AddDefaultCharset UTF-8' to 'AddDefaultCharset ISO-8859-1' on my site, because it was causing problems displaying certain characters properly.

    It didn't matter that I had <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> in my webpages, the apache directive was overriding it.

    If this is the case, edit your httpd.conf file. If you don't have access to edit it, then you can override it using .htaccess...
    AddDefaultCharset ISO-8859-1
    ...or...
    AddDefaultCharset Off

    If you use the latter, you can supply the charset info within your webpage meta tag.

  3. coverlim
    Member
    Posted 9 years ago #

    thanks for the advice. i checked and it is not setting the Default Char set in the conf file. I also tried specifying it with .htaccess to no avail.

    in phmyadmin on both sites, i see the characters im trying to get rid of.

    for latin1_swedish_ci what charset should be specified in the header?

  4. coverlim
    Member
    Posted 9 years ago #

    the database is in latin1_swedish_ci, which means it should be in ISO-8859-1. but the page and the WP install is UTF-8. if i switch all this to ISO-8859-1 it looks even worse. even teh DB settings seem strange... see below.

    mysql> SHOW VARIABLES LIKE 'character\_set\_%';
    +--------------------------+--------+
    | Variable_name | Value |
    +--------------------------+--------+
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    +--------------------------+--------+
    6 rows in set (0.00 sec)

  5. jumbo
    Member
    Posted 9 years ago #

    Did you make the change here as well:
    Options > Reading > Encoding for pages and feeds

  6. coverlim
    Member
    Posted 9 years ago #

    yes i have ... there it is utf-8, but if i switch to iso-8859-1 the caracters look even stranger.

  7. coverlim
    Member
    Posted 9 years ago #

    i also tried exporting the DB for 3.23 support, to remove all teh character set references from teh DB. is exactly the same.

Topic Closed

This topic has been closed to new replies.

About this Topic