Re: EBCDIC sorting as a use case for ICU rules
Daniel Verite <daniel@manitou-mail.org>
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Peter Eisentraut" <peter.eisentraut@enterprisedb.com>
Cc: pgsql-hackers@postgresql.org,
Jeff Davis
<pgsql@j-davis.com>,
Jonathan S. Katz <jkatz@postgresql.org>
Date: 2023-07-17T08:10:19Z
Lists: pgsql-hackers
Attachments
- collation-icu-rules-v2.patch (text/plain) patch v2
Peter Eisentraut wrote: > You can use whitespace in the rules. For example, > > CREATE COLLATION ebcdic (provider='icu', locale='und', > rules=$$ Nice, it's clearly better that the piece of code I had in the previous patch. It can also be made more compact by grouping consecutive code points, for instance <*a-r for 'a' to 'r' I changed it that way, and also moved '^' before '[' and ']', since according to [1], '^' is at location 0xB0 and '[' and ']' at 0xBA and 0xBB. Updated patch attached. [1] https://en.wikipedia.org/wiki/EBCDIC#Code_page_layout Best regards, -- Daniel Vérité https://postgresql.verite.pro/ Twitter: @DanielVerite
Commits
-
doc: Add more ICU rules examples
- 103df207a71e 16.0 landed
- 17ec2c5dfa8d 17.0 landed