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