On Thu, Jun 9, 2022 at 10:54 AM Jeremy Schneider <schnei...@ardentperf.com> wrote: > MySQL did the right thing here by doing what every other RDBMS did, and just > making a simple “good-enough” collation hardcoded in the DB, same across all > platforms, that never changes.
That's not true. Both SQL Server and DB2 have some notion of collations that are versioned. Oracle may not, but then Oracle also handles collations by indexing strxfrm() blobs, with all of the obvious downsides that that entails (far larger indexes, issues with index-only scans). That seems like an excellent example of what not to do. -- Peter Geoghegan
