Horton

Re: locale and german umlauts

Nabil Sayegh <nsmail@sayegh.de>

View thread
From: Nabil Sayegh <nsmail@sayegh.de>
To: nishad@ptolemy.tlg.uci.edu
Cc: Wolfgang Winkler <Wolfgang.Winkler@digitali-concepts.com>, pgsql-bugs@postgresql.org
Date: 2001-08-07T18:37:26Z
Lists: pgsql-bugs 
On 07 Aug 2001 10:53:45 -0700, Nishad Prakash wrote:
> On Wed, 1 Aug 2001, Wolfgang Winkler wrote:
> 
> > export LC_CTYPE=de_DE.ISO8859-1
> > export LC_COLLATE=de_DE.ISO8859-1

If possible, you should use LC_COLLATE=POSIX
everything else is AFAIR really slow.

> 1) Make sure the locale has been set before starting the postmaster
> 2) Try createdb -E <encoding> test

1.1) set PGDATESTYLE=GERMAN before starting postmaster

--
 Nabil Sayegh