Re: postgresql order lowercase before uppercase

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 <http://www.mokadb.com>
>
>
>
> On Thu, Mar 18, 2021 at 4:18 PM basti <mailinglist(at)unix-solution(dot)de
> <mailto: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
> <mailto:mailinglist(at)unix-solution(dot)de>>
> >> Sent: Thursday, March 18, 2021 9:40 AM
> >> To: pgsql-general(at)postgresql(dot)org <mailto: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.