Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server? - Mailing list pgsql-general

From John McKown
Subject Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?
Date
Msg-id CAAJSdjjOVX2DRx3_zriAjgNWfJQ8ofD8+SXntgNqyqHpq27dDw@mail.gmail.com
Whole thread Raw
In response to Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?  (James Keener <jim@jimkeener.com>)
Responses Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?
List pgsql-general
Tree view
On Tue, Dec 12, 2017 at 9:11 AM, James Keener <jim@jimkeener.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

pgsql-general by date:

Previous
From: James Keener
Date:
Subject: Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?
Next
From: James Keener
Date:
Subject: Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?