Horton

Add standard collation UNICODE

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 0d21d4b9bc1f9da9dda29e5c4db0c6dd45408aaa
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2023-03-10T12:35:43Z
Releases: 16.0 
Add standard collation UNICODE

This adds a new predefined collation named UNICODE, which sorts by the
default Unicode collation algorithm specifications, per SQL standard.

This only works if ICU support is built.

Reviewed-by: Jeff Davis <pgsql@j-davis.com>
Discussion: https://www.postgresql.org/message-id/flat/1293e382-2093-a2bf-a397-c04e8f83d3c2@enterprisedb.com

Files

PathChange+/−
doc/src/sgml/charset.sgml modified +28 −3
src/bin/initdb/initdb.c modified +7 −3
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/collate.icu.utf8.out modified +9 −0
src/test/regress/sql/collate.icu.utf8.sql modified +1 −0

Documentation touched

Discussion