Horton

Allow setting the collation strength in ICU tailoring rules

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 905e44152a1d49b90cb8d800dcaaba7981288ae2
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-03-18T07:58:47Z
Releases: 19 (unreleased) 
Allow setting the collation strength in ICU tailoring rules

There was a bug that if you created an ICU collation with tailoring
rules, any strength specification inside the rules was ignored.  This
was because we called ucol_openRules() with UCOL_DEFAULT_STRENGTH for
the strength argument, which overrides the strength.  This was because
of faulty guidance in the ICU documentation, which has since been
fixed.  The correct invocation is to use UCOL_DEFAULT for the strength
argument.

This fixes bug #18771 and bug #19425.

Author: Daniel Verite <daniel@manitou-mail.org>
Reported-by: Ruben Ruiz <ruben.ruizcuadrado@gmail.com>
Reported-by: dorian.752@live.fr
Reported-by: Todd Lang <Todd.Lang@D2L.com>
Discussion: https://www.postgresql.org/message-id/flat/YT2PPF959236618377A072745A280E278F4BE1DA@YT2PPF959236618.CANPRD01.PROD.OUTLOOK.COM
Discussion: https://www.postgresql.org/message-id/flat/18771-98bb23e455b0f367@postgresql.org
Discussion: https://www.postgresql.org/message-id/flat/19425-58915e19dacd4f40%40postgresql.org

Files

PathChange+/−
src/backend/utils/adt/pg_locale_icu.c modified +1 −1
src/test/regress/expected/collate.icu.utf8.out modified +8 −0
src/test/regress/sql/collate.icu.utf8.sql modified +4 −0

Discussion