Re: [GENERAL] Czech Win1250 sorting q - Mailing list pgsql-general

From Robert
Subject Re: [GENERAL] Czech Win1250 sorting q
Date
Msg-id 38534F22.57EA6E8A@robert.cz
Whole thread Raw
In response to Czech Win1250 sorting q  (Robert <robert@robert.cz>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: "Gene Selkov Jr."
Date:
Subject: Re: [GENERAL] c function return not recognized?
Next
From: "R.J."
Date:
Subject: Index of words form a field.