[wp-trac] [WordPress Trac] #58871: support uca14.0.0 collation in database where available
WordPress Trac
noreply at wordpress.org
Mon Sep 18 14:08:57 UTC 2023
#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
More information about the wp-trac
mailing list