Re: Sensitive sort problem?

On Tue, 25 Nov 2003, Andrei Bintintan wrote:

> I give an example:
>
> These are the datas from the table names:
>
> id   n1   n2
> 1   AaAa    AaAa
> 2    X     X
> 3    A     A
> 4   a    a
> 5   ab    ab
> 6   _Y    _Y
> 8   ..a    ..a
> 9   .x    .x
> 7   ...a    ...a
>
> If I run: select * from names order by n1: the result is:
>
> id   n1   n2
> 4   a    a
> 8   ..a    ..a
> 7   ...a    ...a
> 3    A     A
> 1   AaAa    AaAa
> 5   ab    ab
> 9   .x    .x
> 2    X     X
> 6   _Y    _Y
>
> Which I don't think that is right. I don't know what happened. But I
> find that the ASCII char order is not respected here.

As Tom said, you've probably run initdb in a locale other than "C".
For example, I believe the above is correct for en_US.