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

2017-12-12 Thread Tsunakawa, Takayuki
Hi Laurenz, Tom, Peter, Thanks for your suggestions. The practical solution seems to be to override comparison operators of char, varchar and text data types with UDFs that behave as Tom mentioned. From: Peter Geoghegan [mailto:p...@bowt.ie] > That said, the idea of an "EBCDIC collation" seems

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

2017-12-10 Thread Tsunakawa, Takayuki
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