sort

This tag is associated with 3 posts

Collation Torture Test versus Debian

Posted by Jeremy ⋅ May 22, 2025 ⋅ Leave a comment

Collation torture test results are finally finished and uploaded for Debian. https://github.com/ardentperf/glibc-unicode-sorting The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm 🎉️ Buster has glibc 2.28 so it shows lots of changes – as expected. The postgres wiki had claimed that Jessie(8) to Stretch(9) upgrades were safe. … Continue reading →

Default Sort Order in Db2, SQL Server, Oracle & Postgres 17

Posted by Jeremy ⋅ May 22, 2024 ⋅ Leave a comment

TLDR: I was starting to think that the best choice of default DB collation (for sort order, comparison, etc) in Postgres might be ICU. But after spending some time reviewing the landscape, I now think that code-point order is the best default DB collation – mirroring Db2 and Oracle – and linguistic sorting can be … Continue reading →

Did Postgres Lose My Data?

Posted by Jeremy ⋅ March 26, 2023 ⋅ 1 Comment

Hello, let me introduce myself. Today, we’ll pretend that I’m a linguistics researcher. I don’t know much about databases, but I do know a lot about the Balti language of northern Pakistan. That’s why I’m excited about my current translation project. The most interesting part of this translation project is that I’m doing some computer-driven … Continue reading →