Re: How do i setup Postgre to use Norwegian sorting rules?

From: Nis Jørgensen <nis(at)superlativ(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do i setup Postgre to use Norwegian sorting rules?
Date: 2007-09-18 12:10:53
Message-ID: fcof96$eci$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sten Daniel Soersdal skrev:
>
> I've tried different settings of --locale= and --lc_collate=
> But i just can't seem to get norwegian letters to be sorted correctly.
> I've tried googling and manual reading but have had little luck in
> finding it.

So, what values did you try for --locale, and what was the output of initdb?

My guess is that initdb could not find the locale you asked for, and
fell back to the default for your box.

On my Debian system, I had to add

no_NO UTF-8

to /etc/locale.gen and then run

/usr/sbin/locale-gen

before running

initdb --lc_collate=no_NO

Not sure how portable this is to other Linux distros, or other Unices.

Nis

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Robert Wimmer 2007-09-18 13:06:41 Re: Relation does not exist problem
Previous Message Oeschey, Lars (I/EK-142, extern) 2007-09-18 09:59:41 Re: Relation does not exist problem