Re: locale support ?

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

Hi,

Thanks Tom, got it working ok now !

And for anyone else too, I used these switches:

With ./configure --enable-locale and with initdb --locale=fi_FI -E LATIN1 and
just to make sure all databases created with ENCODING = 'LATIN1'

BR,

aarni

On Thursday 05 June 2003 01:48, you wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-06-05 06:04:33 Re: 7.2 -> 7.3 timespan, interval etc.
Previous Message Tom Lane 2003-06-05 04:00:33 Re: Updatable view does not work [oops, quite long!]