by Dave Jesch 5 (21 reviews)

Database Collation Fix

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

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

Database Collation Fix ranks #6,133 among WordPress.org plugins with 1,000+ active installations, is #552 of 4,938 in the Utilities & Tools category, a 5/5 rating from 21 reviews, and was last updated Jul 10, 2026. Data from WordPress.org, refreshed twice daily — see methodology.

Tested up to WP 7.0.4 (Current: 7.1)

v1.2.11 Current Version v1.2.11

Updated 2 months ago Last Update on 10 Jul, 2026

Refreshed 7 hours ago Last Refreshed on

#552 of 4,938 in Utilities & Tools Top 10% by installs Downloads -61.9% this week

View on WordPress.org

Rank

#6,133

-2 this week

Active Installs

1K+

-34.9%

KW Avg Position

37.3

0.5 worse

Downloads

35.7K

+16 today

Support Resolved

— No change

Rating

100%

Review 5 out of 5

5 (21 reviews)

Next Milestone 2K

Total Progress 49.1%

1K+ 2K+

1,000

Ranks to Climb

Growth Needed

8,000,000

Active Installs

Pro

Unlock Exact Install Count

See the precise estimated active installs for this plugin, calculated from real-time ranking data.

Exact install estimates within tiers
Track install growth over time
Milestone progress predictions

Upgrade to Pro

Need 509 more installs to reach 2K+

Rank Changes

Current #6,133

Change

Best #

Upgrade to Pro

Unlock 30-day and 90-day rank history charts with a Pro subscription.

Upgrade Now

Active Installs Growth

Upgrade to Pro

Active Installs 0,000,000+

Growth +0.0%

Peak 0,000,000

Downloads Growth

Downloads

Growth

Peak

Upgrade to Pro

Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.

Upgrade Now

Reviews & Ratings

5.0

21 reviews

Overall 100%

21 (100%)

0 (0%)

Security History

Source: WPVulnerability

2 known vulnerabilities on record · 1 in the last 24 months · checked 1 month ago

Jul 31, 2026

Database Collation Fix [database-collation-fix] < 1.2.11

CVE-2026-15018 · Fixed in v1.2.11
Apr 14, 2023

Database Collation Fix [database-collation-fix] < 1.2.8

CVE-2023-23997 · Fixed in v1.2.8

Track This Plugin

Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.

Start Tracking Free

Plugin Details

Version: 1.2.11
Last Updated: Jul 10, 2026
Requires WP: 4.6+
Tested Up To: 7.0.4
PHP Version: 5.3.1 or higher
Author: Dave Jesch

Support & Rating

Rating: ★ ★ ★ ★ ★ 5
Reviews: 21
Support Threads: 0
Resolved: 0%

Keywords

collation algorithm database Illegal mix of collations migration

Upgrade to Pro

Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.

Upgrade Now

Similar Plugins

Adminify – White Label, Admin Menu Editor, Login Customizer

6K+ installs

#2,751

Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits

30K+ installs

#1,006

Elementor Website Builder – more than just a page builder

10M+ installs

Contact Form 7

10M+ installs

All-in-One WP Migration and Backup

5M+ installs

#10

UpdraftPlus: WP Backup & Migration Plugin

3M+ installs

#15

WPCode - Insert Headers and Footers + Custom Code Snippets - WordPress Code Manager

View all Utilities-and-tools plugins

TL;DR

AI summary of the plugin's readme

This plugin is for WordPress site owners who need to migrate or export their database to environments with different MySQL versions or collation support. It converts database tables and columns from utf8mb4_unicode_520_ci or utf8_unicode_520_ci collation to a more portable collation, preventing import errors and collation mismatch conflicts.

Converts table collations automatically
Fixes unknown collation import errors
Fixes illegal mix of collations error
Updates column-specific collation statements
Runs once daily monitoring
Configurable target collation via wp-config.php
Works on local, staging, or live sites
WooCommerce compatibility fix

Frequently Asked Questions

Common questions about Database Collation Fix

Yes. The Database Collation Fix tool does not change any data. It only changes the Collation Algorithm that is specified for your database columns and indexes.

Yes. Always backup your site before making database changes. The Database Collation Fix tool is unlikely to cause any problems but there is still a small chance that something else (like the version of MySQL/MariaDB that you're using) can have a compatibility issue.

No. The Database Collation Fix tool changes the database. It only needs to do this once. However, future versions of WordPress or one or more of your plugins can also make database changes. These future changes may require updates to keep your Collation Algorithms updated. If you leave the Database Collation Fix tool active, it will scan your database once per day and look for any tables that need to be adjusted, fixing them automatically.