"Tsunakawa, Takayuki" <tsunakawa.ta...@jp.fujitsu.com> writes: > 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.1424884373%40sss.pgh.pa.us#28548.1424884...@sss.pgh.pa.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." As I recall, that question was about converting the server to use EBCDIC strings everywhere. That seems impractical for the reasons I mentioned. But you could probably sort according to EBCDIC order if you were willing to accept some inefficiency: internal to the comparison function, convert each string to EBCDIC on each call. Another way you could imagine is to store EBCDIC strings embedded in bytea values. regards, tom lane
