August 23rd, 2013, 04:14 AM
-
Can postgresql order by ebcdic
Hi
Can postgresql order by ebcdic instead of ascii
August 23rd, 2013, 06:08 AM
-
I'm not aware of a collation for EBCDIC -- as the old joke goes, its more like dealing with a substitution cypher than a character encoding (its funny, but I'm semi-serious).
I'd recommend migrating it to utf8 if possible, though I realize that's not always practical in some situations.
You could define your own collation, of course. That can be a royal pita, since EBCDIC isn't contiguous. (There are gaps between incremental values and letter assignments, so you have to manually assign each value.)
August 23rd, 2013, 07:19 AM
-
Originally Posted by zxq9
I'm not aware of a collation for EBCDIC -- as the old joke goes, its more like dealing with a substitution cypher than a character encoding (its funny, but I'm semi-serious).
I'd recommend migrating it to utf8 if possible, though I realize that's not always practical in some situations.
You could define your own collation, of course. That can be a royal pita, since EBCDIC isn't contiguous. (There are gaps between incremental values and letter assignments, so you have to manually assign each value.)
Thanks