Обсуждение: sort order problem

Поиск
Список
Период
Сортировка

sort order problem

От
MarcinInkielmanmarn@wsisiz.edu.pl
Дата:
hi!

could somebody tell me where is the problem?

i have postgres 7.0.3-4 comming with unstable debian distribution (locales 2.2.1-1, libc6 2.2.1-1)
i am unable to force postgres to sort in correct order when I have national characters (polish)
I tried differents locales settings (i thik that LANG=pl_PL, LC_CTYPE=iso_8859_2 worked previously)
on the backend side and from the clients side. the result is always the same.

could somebady help me?

thx!


Re: sort order problem

От
Piotr Filipczuk
Дата:
On Sun, 18 Feb 2001 MarcinInkielmanmarn@wsisiz.edu.pl wrote:

> hi!
>
> could somebody tell me where is the problem?
>
> i have postgres 7.0.3-4 comming with unstable debian distribution (locales 2.2.1-1, libc6 2.2.1-1)
> i am unable to force postgres to sort in correct order when I have national characters (polish)
> I tried differents locales settings (i thik that LANG=pl_PL, LC_CTYPE=iso_8859_2 worked previously)
> on the backend side and from the clients side. the result is always the same.
>
Backend should be started with locale set (LC_ALL=pl_PL) and database
should be create with encoding LATIN2 (createdb -E LATIN2) and that's all.
I tried this with postgres 6.5.x and 7.0.x on RedHat 6.2 and RedHat 7.0.

                Piotr Filipczuk
                filip@polvoice.pl