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

en_US.utf8. is still 0-9A-Za-z and in my example set (as it's my default
too :))

You'd need a case insensitive collation to do what you described, and I'm
not sure those exist in postgres. (I guess you could always build your own
if you _really_ wanted to.

Jim

On Tue, Dec 12, 2017 at 10:24 AM, John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com>
wrote:

> On Tue, Dec 12, 2017 at 9:11 AM, James Keener <jim(at)jimkeener(dot)com> wrote:
>
>> The default C locale on Linux (I don't know Windows) will sort "digits",
>>> then alphabetic with the lower then upper case of each letter in order
>>> like: "aAbB...zZ"
>>>
>>
>> That's no true at all! The C locales are 0-9A-Za-z
>>
>
> ​Thanks for the correction. Turns out that I forgot that my default locale
> on Linux was en_US.utf8.​
>
>
> --
> I have a theory that it's impossible to prove anything, but I can't prove
> it.
>
> Maranatha! <><
> John McKown
>