On Thu, Jun 9, 2022 at 10:54 AM Jeremy Schneider
<schneider@ardentperf.com> wrote:
> MySQL did the right thing here by doing what every other RDBMS did, and just making a simple “good-enough” collation
hardcodedin 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