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(at)robert(dot)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(at)penguin(dot)cz (mime compatible)