locale support
От | Hans Petter Fasteng |
---|---|
Тема | locale support |
Дата | |
Msg-id | Pine.LNX.3.96.980530000118.1175B-100000@kfaserv1.kfdata.no обсуждение исходный текст |
Ответы |
Re: [ADMIN] locale support
|
Список | 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
В списке pgsql-admin по дате отправления: