Re: locale support ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aarni(dot)ruuhimaki(at)kymi(dot)com
Cc: novice pgsql <pgsql-novice(at)postgresql(dot)org>
Subject: Re: locale support ?
Date: 2003-06-04 22:48:59
Message-ID: 27831.1054766939@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

root <aarni(dot)ruuhimaki(at)kymi(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-05 00:00:32 7.2 -> 7.3 timespan, interval etc.
Previous Message Thiemo Kellner 2003-06-04 20:54:34 Updatable view does not work [oops, quite long!]