Is Database Collation Fix free?

Yes, Database Collation Fix is free to use. It is available as a free plugin on WordPress.org.

How many websites use Database Collation Fix?

Database Collation Fix has 1.0K+ active installations as tracked by WordPress.org.

What are the best Database Collation Fix alternatives?

Popular alternatives to Database Collation Fix include WP All Export – Drag & Drop Export to…, Customizer Export/Import, Advanced Order Export For WooCommerce. You can compare them side-by-side on our comparison pages.

Does Database Collation Fix work with the latest WordPress?

Database Collation Fix has been tested up to WordPress 6.4.8. It requires WordPress 4.6+ and PHP 5.3.1+.

PluginSift

Database Collation Fix

Name: Database Collation Fix
Rating: 5 (21 reviews)
Author: Dave Jesch

Convert tables using utf8mb4_unicode_520_ci or utf8_unicode_520_ci collation to a more portable Collation Algorithm.

By Dave Jesch·Export·Free

5(21 reviews)

·1.0K+ active installs·Updated 2 years ago

Download Compare

As of April 2026, Database Collation Fix is a WordPress export plugin with 1.0K+ active installations and a 5/5 rating from 21 reviews. It has been downloaded 29K+ times in total. Requires WordPress 4.6+ and PHP 5.3.1+. Available on WordPress.org since 2017. Last updated 2 years ago — may have compatibility concerns. Downloads are down 17% this week. Top alternative: WP All Export – Drag & Drop Export to….

5/521 reviews

1.0K+active installs

29K+total downloads

9 yearssince 2017

Overview

Since version 4.2, WordPress has been detecting the MySQL version and if it’s version 5.5.3 or greater, automatically selecting the ‘utf8mb4_unicode_520_ci’ Collation Algorithm. This works well until you need to migrate your database to an older version of MySQL that does not support the utf8mb4 algorithms. Then, you run into the error message: “#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci'” when importing your database.

With the WordPress 5.7 update and WooCommerce 5.1, some users are reporting an error: “SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT)”. The Database Collation Fix tool also fixes this issue by changing the collation of all columns…

Read full description on WordPress.org