Re: Issues with german 'Umlaute' - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Issues with german 'Umlaute'
Date
Msg-id 811.1035381864@sss.pgh.pa.us
Whole thread Raw
In response to Issues with german 'Umlaute'  (Nicolaus Erichsen <nico.erichsen@hsh-berlin.com>)
Responses Re: Issues with german 'Umlaute'  ("Iavor Raytchev" <iavor.raytchev@verysmall.org>)
List pgsql-bugs
Nicolaus Erichsen <nico.erichsen@hsh-berlin.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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: now() gives the time of the last commit, not the time it
Next
From: Tom Lane
Date:
Subject: Re: 'pg_dump --create' forgets database encoding