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)
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!] |