collation

This tag is associated with 4 posts

PGConf.dev 2026 Trip Summary

Posted by Jeremy ⋅ May 26, 2026 ⋅ Leave a comment

I’m back home from Vancouver. What a great week – in every way. I’ll try to share a few highlights here. Updated Happiness Hints First and foremost: after many years, the Happiness Hints have received a major update! Before the conference, I updated the hints based on all the feedback I’ve collected over the past … Continue reading →

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

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 →