Re: locale support ? - Mailing list pgsql-novice

From Tom Lane
Subject Re: locale support ?
Date
Msg-id 27831.1054766939@sss.pgh.pa.us
Whole thread Raw
In response to locale support ?  (root <aarni.ruuhimaki@kymi.com>)
Responses Re: locale support ?  (root <aarni.ruuhimaki@kymi.com>)
List pgsql-novice
root <aarni.ruuhimaki@kymi.com> writes:
> I just configured and installed 7.3.3 with --enable-locale and did
> initdb with -E LATIN1. Aim was to have names sorted correctly with
> scandinavian alphabet.  But still my �'s and �'s are within a's
> when listing and sorting by name like there were no umlauts.

Sounds like you didn't have the right locale in force when you ran
initdb.  (You can use pg_controldata to verify the locale settings
that were stored by initdb.)

> How to set this right ?

re-initdb I'm afraid :-(

            regards, tom lane

pgsql-novice by date:

Previous
From: root
Date:
Subject: locale support ?
Next
From: Thiemo Kellner
Date:
Subject: Updatable view does not work [oops, quite long!]