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

From David Sauer
Subject Re: [GENERAL] Czech Win1250 sorting q
Date
Msg-id m2iu25eyiw.fsf@chameleon.localdomain
Whole thread Raw
In response to Czech Win1250 sorting q  (Robert <robert@robert.cz>)
List pgsql-general
>>>> "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: Rick Dearman
Date:
Subject: Getting lists of databases
Next
From: Frank Miles
Date:
Subject: c function return not recognized?