[wp-trac] [WordPress Trac] #60096: Remove back-compat for database servers that don't support utf8mb4

[WordPress Trac]

#60096: Remove back-compat for database servers that don't support utf8mb4
--------------------------------------+--------------------------
 Reporter:  johnbillion               |       Owner:  johnbillion
     Type:  task (blessed)            |      Status:  assigned
 Priority:  normal                    |   Milestone:  6.6
Component:  Database                  |     Version:  trunk
 Severity:  normal                    |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:
--------------------------------------+--------------------------

Comment (by OllieJones):

 The release notes for the MySQL 5.5 version series are here.
 https://downloads.mysql.com/docs/mysql-5.5-relnotes-en.pdf

 They state that version 5.5.3 (24-March-2010) was the first version in
 which utf8mb4 appeared. See page 159 of that big pdf. That was a major
 feature release.

 MariaDB's 5.5 series started with 5.5.20 (25-Feb-2012).
 https://mariadb.com/kb/en/release-notes-mariadb-55-series/

 **So, semantic version checking of version 5.5.3 should be fine to reject
 older MySQL versions. 5.5.5 is also fine.**

 The WordPress stats page (https://wordpress.org/about/stats/)
 unfortunately doesn't discriminate between point releases of MySQL /
 MariaDB, instead bundling 5.5.x into a single percentage (12.7% as of late
 Feb 2024). I suspect almost everybody has upgraded beyond 5.5.3.

 Uploads from users of my indexing plugin show nothing earlier than MariaDB
 5.5.68. But that doesn't mean mcuh of anything: my plugin's users are
 self-selecting.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/60096#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform