[wp-trac] [WordPress Trac] #58871: support uca14.0.0 collation in database where available

[WordPress Trac]

#58871: support uca14.0.0 collation in database where available
-------------------------------------------------+-------------------------
 Reporter:  danielblack                          |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
                                                 |  Review
Component:  Database                             |     Version:  6.3
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing                                        |
-------------------------------------------------+-------------------------

Comment (by craigfrancis):

 Thanks @danielblack

 Not got time to check atm, but assuming we will `ALTER TABLE` to avoid the
 "Illegal mix of collations" issue, do you know how the system will
 respond; i.e. will it be a full table lock while it's being updated
 (imagine a 10GB table, will that cause the website to be unavailable for
 seconds, minutes, hours? I suspect InnoDB might do better than MyISAM).

 Also, failure on my part, but thought I should share... I updated a
 database yesterday (MariaDB 10.11.5 on RDS), but I forgot my backup
 servers run Ubuntu 22.04.3 LTS, which provides MariaDB 10.6.12 (the "long-
 term maintenance stable version"), so it could not import the dump (I do
 this to verify the backups work).

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