Re: EBCDIC sorting as a use case for ICU rules

On 6/21/23 09:28, Daniel Verite wrote:
> In the "Order changes in PG16 since ICU introduction" discussion, one
> sub-thread [1] was about having a credible use case for tailoring collations
> with custom rules, a new feature in v16.
>
> At a conference this week I was asked if ICU could be able to
> sort like EBCDIC [2]. It turns out it has been already asked on
> -general a few years ago [3] with no satisfactory answer at the time ,
> and that it can be implemented with rules in v16.

Oh, very cool! I have seen the requirement for EBCDIC come up multiple
times over the years.

<snip>

> Maybe this example could be added to the documentation except for
> the problem that the rule is very long and dollar-quoting cannot be split
> into several lines. Literals enclosed by single quotes can be split that
> way, but would require escaping the single quotes in the rule, which
> would lead to scary-looking over-quoted contents.
>
> I'm open to suggestions on whether this EBCDIC example is worth being in the
> doc in some form or putting this in the wiki would be good enough.

I would definitely favor adding to the docs, but no idea how to deal
with the length issue.

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com