Title: Charset Alteration Problem
Last modified: August 30, 2016

---

# Charset Alteration Problem

 *  [ulasunsalanlg](https://wordpress.org/support/users/ulasunsalanlg/)
 * (@ulasunsalanlg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/charset-alteration-problem/)
 * Hi everyone,
 * I created a website and wordpress and exported my database from phpmyadmin. Then
   when I tried to import the database to my hosting providers phpmyadmin, I had
   the unknown charset error. My databases charset is utf8mb4 but my hosting provider
   requires it to be utf8, due to older version.
 * Then I changed the charset of the tables in my database by executing the command
   of “ALTER TABLE X CONVERT TO CHARACTER SET X” command. It worked, except two 
   tables: wp_icl_translate_job and wp_term_relationships. How can I change the 
   charsets of these two?
 * Thanks in advance.

Viewing 1 replies (of 1 total)

 *  Thread Starter [ulasunsalanlg](https://wordpress.org/support/users/ulasunsalanlg/)
 * (@ulasunsalanlg)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/charset-alteration-problem/#post-6722342)
 * *website with wordpress

Viewing 1 replies (of 1 total)

The topic ‘Charset Alteration Problem’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [ulasunsalanlg](https://wordpress.org/support/users/ulasunsalanlg/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/charset-alteration-problem/#post-6722342)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics