Title: removing foreign characters from database
Last modified: August 22, 2016

---

# removing foreign characters from database

 *  [hannahpt](https://wordpress.org/support/users/hannahpt/)
 * (@hannahpt)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/removing-foreign-characters-from-database/)
 * I’m getting collation errors on my site like this:
    [07-Dec-2014 16:33:22 UTC]
   WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
   and (utf8_general_ci,COERCIBLE) for operation ‘=’ for query SELECT comment_ID
   FROM wp_comments WHERE comment_post_ID = 2084 AND comment_parent = ‘0’ AND comment_approved!
   = ‘trash’ AND ( comment_author = ‘非常にアクセサリー ショルダーバッグボストン’)
   AND comment_content = ‘**非常にアクセサリー ショルダーバッグボストン**\n\nWhat
   Defines Israeli Parenting?’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘
   wp-includes/template-loader.php’), include(‘wp-trackback.php’), wp_new_comment,
   wp_allow_comment
 * I’d like to avoid having to switch all of the collations to utf8, as I don’t 
   actually need any characters other than latin. These comments are all spam anyway.
   I’ve emptied my comment trash folder–could it be that these comments are still
   there somewhere? I’ve searched the database for the character string without 
   success.
    And another question–why is the site calling up these comments in the
   first place?

The topic ‘removing foreign characters from database’ is closed to new replies.

## Tags

 * [collation](https://wordpress.org/support/topic-tag/collation/)
 * [non latin characters](https://wordpress.org/support/topic-tag/non-latin-characters/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [hannahpt](https://wordpress.org/support/users/hannahpt/)
 * Last activity: [11 years, 6 months ago](https://wordpress.org/support/topic/removing-foreign-characters-from-database/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics