Locale and mb help - Mailing list pgsql-general

Hi all:

    I'm using Postgres-6.5.3 with Red Hat 6.0 and I've a problen using
LC_TYPE and LC_COLLATE ...

    I compiled Postgres --wiht-locale --with-mb=LATIN1.

    I did initdb -e LATIN1

    And finally I createdb -E LATIN1 test.

    I also have defined

        LC_TYPE=LATIN1 and
        LC_COLLATE=LATIN1

    when postmaster starts.

    So now, I try to select * from test1 order by ...

    The problem is that I do not get the result sorted as I would.
What's wrong? What should I do?

    Thanks to all,

jjprat