locale support

From: Hans Petter Fasteng <hansf(at)kfaserv1(dot)kfdata(dot)no>
To: pgsql-admin(at)hub(dot)org
Subject: locale support
Date: 1998-05-30 00:09:34
Message-ID: Pine.LNX.3.96.980530000118.1175B-100000@kfaserv1.kfdata.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I know that this surtanlly has bean asked and maybe it should be in a
diffirent list too. but anywhay, I have set up a postgres 6.3.2 system
for users on the network I am admin on, since we are in Norway norwegian
sorting is a must to my users. I have compiled with enambe-locale and
installed locale I have tested the local installation with a little date
program and the date is coming out in Norwegian format with the name of
the day in Norwegian. But I can not make postgres to sort norwegian
letters. I have scanned the FAQ and searched the postgres site, and found
a lot of messages adressing locale, but non that fits into my probelm.

I hope to help my users sort correctly, do I have to tell pgsql not only
to use order by but also give a speshal character to enable sorting in
the way the locale setup spesifyes? My locale setup is:

LANG=no_NO
LC_CTYPE=no_NO
LC_COLLATE=no_NO
LC_DATE=no_NO

I have tried to put ISO-8859-1 in the LC_CTYPE with no success, I am
testing this by etring the locale vars into postgres users .profile
and starting postmaster from the shell after I have loged in, so that I
should be shure that postmaster can see my envirment vars.

Plase give me some assistance I have also red the lines in the
documentation shipped with postgres.

-hans

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Mount 1998-05-30 11:45:22 Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.
Previous Message Oleg Broytmann 1998-05-29 23:32:22 Re: [ADMIN] locale support