Re: [GENERAL] Czech Win1250 sorting q

From: David Sauer <davids(at)penguin(dot)cz>
To: pgsql-general(at)postgreSQL(dot)org
Cc: Robert <robert(at)robert(dot)cz>
Subject: Re: [GENERAL] Czech Win1250 sorting q
Date: 1999-12-12 01:30:31
Message-ID: m2iu25eyiw.fsf@chameleon.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>> "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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Miles 1999-12-12 05:19:28 c function return not recognized?
Previous Message Rick Dearman 1999-12-11 23:51:59 Getting lists of databases