[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
-------------------------------------------------+-------------------------
Changes (by craigfrancis):

 * severity:  major => normal


Comment:

 Replying to [comment:13 oxfordmetadata]:
 > @craigfrancis  Hello! Shall you please finalize this?

 Please be nice; and the AI output isn't helping... as noted above
 ([https://core.trac.wordpress.org/ticket/58871?replyto=13#comment:4 #4]
 and [https://core.trac.wordpress.org/ticket/58871?replyto=13#comment:6
 #6)], `mysqli_get_server_info()` is currently used to determine if
 `utf8mb4` and `utf8mb4_520` is available, it's not ideal, but it works and
 is fast... unfortunately it doesn't work with the requested change, and
 the alternatives suggested so far have their own problems (e.g.
 performance impact; and the different names in use - uca1400_ai_ci,
 utf8mb4_0900_ai_ci, and utf8mb4_unicode_520_ci).

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