On Tue, 12 Dec 2017 07:18:10 -0600, John McKown
<john.archie.mckown@gmail.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