Is it possible to sort strings in EBCDIC order in PostgreSQL server?

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is it possible to sort strings in EBCDIC order in PostgreSQL server?
Date: 2017-12-11 07:09:41
Message-ID: 0A3221C70F24FB45833433255569204D1F84A7AD@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

It is embarrassing to ask such a thing, but is there any way to sort character column values in EBCDIC order inside the PostgreSQL server? i.e. is it possible to use EBCDIC collation in PostgreSQL, say, by using ICU or something? We need to run on a certain mainframe.

I see almost no hope from the following, but let me make sure.

https://www.postgresql.org/message-id/flat/28548(dot)1424884373%40sss(dot)pgh(dot)pa(dot)us#28548(dot)1424884373(at)sss(dot)pgh(dot)pa(dot)us

"Hmm ... EBCDIC ... is that mandatory? Because there are a pretty large
number of ASCII dependencies in PG, mostly arising from our support of
multibyte character sets, which are all expected to be ASCII supersets.
If there's not a way to run the server process in ASCII-land, you're
likely dead in the water. I would not want to try to ferret out all
the dependencies."

Regards
Takayuki Tsunakawa

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2017-12-11 07:15:23 Re: Removing INNER JOINs
Previous Message Jim Finnerty 2017-12-11 04:33:21 Re: Removing INNER JOINs