postgres.git / summary / log / commit / refs

commit    9f358c5ef31327f7a67af783f5f37468bbac3aed
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Thu Sep 10 13:31:09 2020 +0000
First released in: 14.0, 10.15, 11.10, 12.5, 13.0

    doc: Remove buggy ICU collation from documentation
    
    We have had multiple reports that point to the
    '@colReorder=latn-digit' collation customization being buggy.  We have
    reported this to ICU and are waiting for a fix.  In the meantime,
    remove references to this from the documentation and replace it by
    another reordering example.  Apparently, many users have been picking
    up this example specifically from the documentation.
    
    Author: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
    Discussion: https://www.postgresql.org/message-id/flat/153201618542.1404.3611626898935613264%40wrigleys.postgresql.org


doc/src/sgml/charset.sgml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml index 4b4563c5b9d..2745b444176 100644 --- a/doc/src/sgml/charset.sgml +++ b/doc/src/sgml/charset.sgml @@ -791,11 +791,11 @@ CREATE COLLATION german (provider = libc, locale = 'de_DE'); </varlistentry> <varlistentry> - <term><literal>CREATE COLLATION digitslast (provider = icu, locale = 'en-u-kr-latn-digit');</literal></term> - <term><literal>CREATE COLLATION digitslast (provider = icu, locale = 'en@colReorder=latn-digit');</literal></term> + <term><literal>CREATE COLLATION latinlast (provider = icu, locale = 'en-u-kr-grek-latn');</literal></term> + <term><literal>CREATE COLLATION latinlast (provider = icu, locale = 'en@colReorder=grek-latn');</literal></term> <listitem> <para> - Sort digits after Latin letters. (The default is digits before letters.) + Sort Greek letters before Latin ones. (The default is Latin before Greek.) </para> </listitem> </varlistentry> @@ -811,9 +811,9 @@ CREATE COLLATION german (provider = libc, locale = 'de_DE'); </listitem> </varlistentry> - <varlistentry> - <term><literal>CREATE COLLATION special (provider = icu, locale = 'en-u-kf-upper-kr-latn-digit');</literal></term> - <term><literal>CREATE COLLATION special (provider = icu, locale = 'en@colCaseFirst=upper;colReorder=latn-digit');</literal></term> + <varlistentry> + <term><literal>CREATE COLLATION special (provider = icu, locale = 'en-u-kf-upper-kr-grek-latn');</literal></term> + <term><literal>CREATE COLLATION special (provider = icu, locale = 'en@colCaseFirst=upper;colReorder=grek-latn');</literal></term> <listitem> <para> Combines both of the above options. [parent: 727f6fb8f71f]