Re: postgresql order lowercase before uppercase

or, maybe, just nothing ?

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Thu, Mar 18, 2021 at 4:44 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> Exactly. "C" collation is the opposite of what he wants.
>
> OP needs something like "de_DE".
>
> On 3/18/21 10:36 AM, Marc Millas wrote:
>
> to me, collate 'C' ask for the raw ascii order which put caps before
> because the hexa coding is lower
> did you try any thing else (POSIX is same as 'C')
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Thu, Mar 18, 2021 at 4:18 PM basti <mailinglist(at)unix-solution(dot)de>
> wrote:
>
>> This does not help in that case.
>>
>> On 18.03.21 15:45, Basques, Bob (CI-StPaul) wrote:
>> > Maybe check out using the UPPER/LOWER/INITCAP functions in the order
>> by clause?
>> >
>> > Bobb
>> >
>> >
>> >
>> >> -----Original Message-----
>> >> From: basti <mailinglist(at)unix-solution(dot)de>
>> >> Sent: Thursday, March 18, 2021 9:40 AM
>> >> To: pgsql-general(at)postgresql(dot)org
>> >> Subject: postgresql order lowercase before uppercase
>> >>
>> >> Think Before You Click: This email originated outside our organization.
>> >>
>> >>
>> >> Hello,
>> >> I need to as follow:
>> >>
>> >> ande
>> >> Amma
>> >> Anit
>> >> Anti
>> >> Brac
>> >> Cali
>> >> ....
>> >>
>> >> I have try ORDER by name COLLATE 'C';
>> >>
>> >> but this order as follow:
>> >>
>> >> Amma
>> >> Anit
>> >> Anti
>> >> Brac
>> >> Cali
>> >> ....
>> >> ande
>> >>
>> >> Best Regards
>> >>
>> >
>>
>>
>>
> --
> Angular momentum makes the world go 'round.
>