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

On Tue, 12 Dec 2017 07:18:10 -0600, John McKown
<john(dot)archie(dot)mckown(at)gmail(dot)com> wrote:

>?This is a guess on my part, based on many years on an EBCDIC system. But
>I'll bet that they are doing a conversion off of the EBCDIC system (maybe
>Db2 on z/OS) to an ASCII system (Linux or Windows) running PostgreSQL. They
>want to be able to compare the output from the existing system to the
>output on the new system.

[he asks naively:]

If a port off the EBCDIC system really is the case, wouldn't it be
easier just to write an external compare tool? Or maybe a PG
function to convert UTF strings as EBCDIC so as to compare string
column dumps?

Either of the above seems more rational than putting a whole lot of
effort into creating an EBCDIC collation.

[Not that it is terribly hard to create a new collation. It's more a
matter of "why bother?" when you are trying to move away from that
system in the 1st place.]

YMMV,
George