Locale settings

From: "Tille, Andreas" <TilleA(at)rki(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Locale settings
Date: 2002-04-22 11:59:22
Message-ID: Pine.LNX.4.44.0204221353170.5104-100000@wr-linux02.rki.ivbb.bund.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've thought that I would have set my locale settings correctly for
PostgreSQL 7.1.3. At least I have set my environment variables

LANG=de_DE(at)euro
LC_ALL=de_DE(at)euro

Do I have to set additional LC_COLLATE and LC_CTYPE to avoid the
following warnings

Apr 22 12:22:13 wr-linux02 postgres[16149]: [2] NOTICE: pg_setlocale():
'LC_COLLATE=žæ,@žæ,@/locale' cannot be honored.
Apr 22 12:22:13 wr-linux02 postgres[16149]: [3] NOTICE: pg_setlocale():
'LC_CTYPE=°æ,@°æ,@^P' cannot be honored.

which where caused when I try

to_char(temperatur, '999D9')

(By the way: It is not really important to get a ',' instead of the '.'
but would be nice. My most important concern is to get rid of this
warning cleanly - which means not by switching of this warning level.)

Kind regards

Andreas.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jacob Vennervald Madsen 2002-04-22 12:50:10 Foreign keys
Previous Message Peter Peltonen 2002-04-22 10:47:44 Re: configure: error: header file <openssl/err.h> is