[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 needs-refresh                          |  performance
-------------------------------------------------+-------------------------

Comment (by oxfordmetadata):

 @craigfrancis I just do not have enough data to convey to you how much
 better a server with about 40 applications performs. I am in the process
 in changing to uca_1400 as we speak :)

 I think this function ought to run once during initial installation. Else
 as you move from one service provider to the other, you may end up with 4
 (four) different collations - as it was in many of our customers.

 I mean we had one guy who moved from say MariaDB 8 or 9, to MySQL 5.7,
 then to MySQL 8, then to MariaDB 10.4 and now with us on MariaDB 11.4. It
 seemed to me that as they were adding plugins/features in each  host, the
 collations were proliferating.

 Keep well!

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