[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):

 Replying to [comment:9 danielblack]:
 > So what's the implication here, need to pin to the charset/collation of
 the original install?

 I think that will be for someone else to decide... @pento, as you looked
 at #38036, and worked on #21212, do you have any thoughts on changing
 `utf8mb4_unicode_520_ci` to `utf8mb4_uca1400_ai_ci` (MariaDB) or
 `utf8mb4_0900_ai_ci` (MySQL)?

 i.e. using a query to find out which collations are supported, and running
 an `ALTER TABLE` during upgrade.

 ----

 > There are 10.11 packages for 22.04 ([https://mariadb.org/download/?t
 =repo-config&d=22.04+%22jammy%22&v=10.11 link])

 Thanks, but `apt-get upgrade` on a nightly cron is safer than me
 forgetting to apply patches :-)

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