Title: character set problems
Last modified: August 18, 2016

---

# character set problems

 *  [coverlim](https://wordpress.org/support/users/coverlim/)
 * (@coverlim)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/)
 * 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?

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

 *  [jumbo](https://wordpress.org/support/users/jumbo/)
 * (@jumbo)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-287994)
 * 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.
 *  Thread Starter [coverlim](https://wordpress.org/support/users/coverlim/)
 * (@coverlim)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-287997)
 * 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?
 *  Thread Starter [coverlim](https://wordpress.org/support/users/coverlim/)
 * (@coverlim)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-288009)
 * 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)
 *  [jumbo](https://wordpress.org/support/users/jumbo/)
 * (@jumbo)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-288085)
 * Did you make the change here as well:
    Options > Reading > Encoding for pages
   and feeds
 *  Thread Starter [coverlim](https://wordpress.org/support/users/coverlim/)
 * (@coverlim)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-288174)
 * yes i have … there it is utf-8, but if i switch to iso-8859-1 the caracters look
   even stranger.
 *  Thread Starter [coverlim](https://wordpress.org/support/users/coverlim/)
 * (@coverlim)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-288176)
 * i also tried exporting the DB for 3.23 support, to remove all teh character set
   references from teh DB. is exactly the same.

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

The topic ‘character set problems’ is closed to new replies.

## Tags

 * [character](https://wordpress.org/support/topic-tag/character/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [set](https://wordpress.org/support/topic-tag/set/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [coverlim](https://wordpress.org/support/users/coverlim/)
 * Last activity: [20 years, 6 months ago](https://wordpress.org/support/topic/character-set-problems-1/#post-288176)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics