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

 > MySQL will move from 8.1 to 10.10 at some point.

 Yep, seems about 5 years at a rough guess.

 > Maybe use SHOW CHARACTER SET?

 SHOW COLLATION is a bit more direct, and MySQL have supported it for a
 while too (5.5 example - https://dbfiddle.uk/PCg3HiK3).

 MariaDB [(none)]> show collation where Collation='uca1400_ai_ci';
 +---------------+---------+------+---------+----------+---------+
 | Collation     | Charset | Id   | Default | Compiled | Sortlen |
 +---------------+---------+------+---------+----------+---------+
 | uca1400_ai_ci | NULL    | NULL | NULL    | Yes      |       8 |
 +---------------+---------+------+---------+----------+---------+

 I'll get this incorporated.

 > Also, do we want WordPress to be accent-insensitive by default?
 WordPress is currently case-insensitive by default.

 Yes, I was just following the insensitive theme there. I haven't any
 justification either way to thing accent sensitive is more important than
 case sensitive.

 > Slightly off topic, the MariaDB Jira ticket MDEV-30164 gets MariaDB
 11.2.1 to support:

 Nice. I hadn't come across this change. By "slightly off topic" I assume
 its not necessary to handle here, however if it was, and its desired, can
 you create a ticket with rough guidance on how you want it implemented.

 Yes, you're right, MariaDB has no 9.0.0 collation support. Bumping to
 14.0.0 was a large enough body of work without incorporating an
 intermediate version.

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