Thread: locale & mb support

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

On Tue, 7 Mar 2000, Gabriel Fernandez wrote:
>     The problem is that I do not get the result sorted as I would.
> What's wrong? What should I do?

   First, test your locale. Look int src/test/locale directory. There
you'll find some test. You should create similar test for your locale (and
I'd be happy if you send your test to me).

   If your locale tested Ok - stop postmaster and rerun initdb -E LATIN1.
I heared this solution few times, and once it helped me.

   BTW, you don't nned to pass LC_CTYPE to postmaster - it can be defined
on per client basis - so define it before invoking psql or other client
(similar to what you'll find in locale tests)...

Oleg.
----
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.