Обсуждение: Latin-2 sort order

Hello,

since a few hours I try to set-up Latin-2 sort order in PostgreSQL 7.1.3. I
have re-compiled it with MB and Latin2, I have re-initialized database, I
have restored dumps, which contained "ENCODING='LATIN2'" in it ... and it's
still nothing.

Could anyone send me a step-by-step instruction, or at least some URL?

Please, I know it's RTFM-type-question, but the time is against me. 

I'm usint PGSQL on FreeBSD 4.3-STABLE.

-- 
[ Michal Pasternak     doc@lublin.t1.pl     +48606570000  ]
[ sklepy internetowe, bazy danych, programy na zamówienie ]
[ . .. ..- .- . .. http://lublin.t1.pl . .-. .--.. . . .- ]

> since a few hours I try to set-up Latin-2 sort order in PostgreSQL 7.1.3. I
> have re-compiled it with MB and Latin2, I have re-initialized database, I
> have restored dumps, which contained "ENCODING='LATIN2'" in it ... and it's
> still nothing.

You need to enable locale support. MB support does nothing with the
sort order.
--
Tatsuo Ishii

> > You need to enable locale support. MB support does nothing with the
> > sort order.
> 
> I guess You mean:
> 
>     ./configure --enable-locale
>     export LANG=pl_PL
>     run postmaster

Yes.

> and now should I
> 
>     initdb 
>     
> or just simply browse the database as usual?

I'm afraid you are forced initdb.

I think postmaster coming with PostgreSQL 7.1 or later won't start up
if locale is enabled and the specified locale is different from the
initdb time (if locale is not enabled in PostgreSQL, the current
locale would be assumed as C).
--
Tatsuo Ishii