Identify the version of a collation from ICU in Postgres
2
votes
2
answers
2040
views
Postgres 10 and later incorporates the International Components for Unicode (ICU) library for text-handling and other internationalization issues.
Changes happen to human languages, such as sorting rules evolving. Therefore collation definitions are versioned in ICU.
➥ How can I identify the version number of a collation?
I know Postgres will report version number as part of a collation version mismatch error message. Is there a way to proactively query for the version rather than wait for an error message?
Asked by Basil Bourque
(11188 rep)
Aug 4, 2019, 03:16 AM
Last activity: Mar 11, 2025, 06:36 AM
Last activity: Mar 11, 2025, 06:36 AM