Re: [GENERAL] Czech Win1250 sorting q

netkof=> show client encoding;
ERROR:  parser: parse error at or near "encoding"
netkof=> set client encoding to 'WIN1250';
ERROR:  parser: parse error at or near "encoding"
netkof=> set client-encoding to 'WIN1250';
ERROR:  parser: parse error at or near "-"

Hmm, what did you say I should write? Well, this is PG6.5.2 installed
from RPM, should it be compiled with some special option? Thanks.

- Robert


David Sauer wrote:

> >>>> "Robert" == Robert  <robert@robert.cz> writes:
>
>     Robert> Hi, ISO-8851-2 Czech support (esp. sorting) works fine, but my
>     Robert> data use Win1250. PG 6.5.1+ is supposed to support it, can some
>     Robert> kind soul tell me how can I use it? Thanks.
>
>     Robert> - Robert
>
> Just do:
>
> set client encoding to 'WIN1250';
>
>  Server will store its data in iso-8859-2, but will recode input and
> output for windoze clients.
>
>   The reason is, that postgres database server uses locales to sort tables
> and there is no 'cs_CZ.WIN-1250' locale - and I hope, that never will be.
>
> --
> * David Sauer, student of Czech Technical University
> * electronic mail: davids@penguin.cz (mime compatible)