Title: Getting SQL COLLATION error
Last modified: November 18, 2020

---

# Getting SQL COLLATION error

 *  Resolved [Marco Almeida | Webdados](https://wordpress.org/support/users/webdados/)
 * (@webdados)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/getting-sql-collation-error/)
 * I’m getting this error while updating the TranslatePress database after last 
   update:
 * `[18-Nov-2020 10:00:19 UTC] Erro na base de dados do WordPress COLLATION 'utf8mb4_bin'
   is not valid for CHARACTER SET 'latin1' na query UPDATE wp_trp_dictionary_pt_pt_en_gb,
   wp_trp_original_strings SET wp_trp_dictionary_pt_pt_en_gb.original_id = wp_trp_original_strings.
   id WHERE wp_trp_dictionary_pt_pt_en_gb.original COLLATE utf8mb4_bin = wp_trp_original_strings.
   original AND wp_trp_dictionary_pt_pt_en_gb.id > 0 AND wp_trp_dictionary_pt_pt_en_gb.
   id <= 5000 feita por do_action('wp_ajax_trp_update_database'), WP_Hook->do_action,
   WP_Hook->apply_filters, TRP_Upgrade->trp_update_database, TRP_Upgrade->trp_updated_database_original_id_update_166,
   TRP_Query->original_ids_reindex`
 * Any idea of what’s going on here?

Viewing 1 replies (of 1 total)

 *  Plugin Author [Razvan Mocanu](https://wordpress.org/support/users/razvanmo-1/)
 * (@razvanmo-1)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/getting-sql-collation-error/#post-13687115)
 * Hi,
 * We use wpdb->get_charset_collate() function to determine the collation of the
   database. In your case there is a mismatch. Judging by the error you received,
   the expected return is latin1, but instead it returns something else.
 * Try checking and changing DB_COLLATE to latin1 in wp-config.php. Same with DB_CHARSET
   if already set.
 * Before taking any actions I recommend backing up database and files to safely
   restore in case something goes wrong.

Viewing 1 replies (of 1 total)

The topic ‘Getting SQL COLLATION error’ is closed to new replies.

 * ![](https://ps.w.org/translatepress-multilingual/assets/icon.svg?rev=3166541)
 * [TranslatePress - Translate Multilingual sites with AI Translation](https://wordpress.org/plugins/translatepress-multilingual/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/translatepress-multilingual/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/translatepress-multilingual/)
 * [Active Topics](https://wordpress.org/support/plugin/translatepress-multilingual/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/translatepress-multilingual/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Razvan Mocanu](https://wordpress.org/support/users/razvanmo-1/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/getting-sql-collation-error/#post-13687115)
 * Status: resolved