Skip site navigation (1) Skip section navigation (2)

Re: Issues with german 'Umlaute'

From: "Iavor Raytchev" <iavor(dot)raytchev(at)verysmall(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Nicolaus Erichsen" <nico(dot)erichsen(at)hsh-berlin(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Issues with german 'Umlaute'
Date: 2002-10-23 20:00:49
Message-ID: HKEIIDPFPDBMOMDLIEEGIEJPDHAA.iavor.raytchev@verysmall.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:

>
> Nicolaus Erichsen <nico(dot)erichsen(at)hsh-berlin(dot)com> writes:
> > I recently found a problem with sorting german 'Umlaute' .
>
> Sounds like you did not set the right locale when creating
> the database.
> You need to be careful to run initdb with LANG (or LC_ALL or at least
> LC_COLLATE) set to what you want, probably "de_DE".
>
> > All this happens with a database  created with encoding ='latin1'.
>
> Encoding is not the issue, locale is.

Then what about having German, English, Italian and French words in the
same database? Shall we create four databases and place each language in
a separate one?

Iavor

--
Iavor Raytchev
very small technologies (a company of CEE Solutions)

www.verysmall.org



In response to

pgsql-bugs by date

Next:From: Andrew McMillanDate: 2002-10-24 00:02:15
Subject: Re: [BUGS] Optimization disaster
Previous:From: Bruce MomjianDate: 2002-10-23 19:22:54
Subject: Re: [BUGS] psql does not invoke pager on \h *

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group