From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
---|---|
To: | "Thomas Beutin" <tyrone(at)laokoon(dot)IN-Berlin(dot)DE>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: One source of constant annoyance identified |
Date: | 2002-06-28 19:22:46 |
Message-ID: | 2266D0630E43BB4290742247C8910575014CE2B9@dozer.computec.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
-----Ursprüngliche Nachricht-----
Von: Thomas Beutin
Gesendet: Fr 28.06.2002 19:43
An: pgsql-general(at)postgresql(dot)org
Cc:
Betreff: Re: [GENERAL] One source of constant annoyance
identified
> Environment-variables RC_LANG/LC_CTYPE are set to de_DE(at)euro,
encoding
> for the databases is SQL_ASCII. As we are hosting german
websites and
> communities, we need to sort data containing characters
ÄÖÜäöüß in the
> correct context (AÄ,OÖ,UÜ,sß), so I figured we'd need locale
support.
AFAIK the compiling options are ok, but did You the initdb
command with
the proper LC_ALL env set? It shoul be de_DE or de_DE(at)euro(dot)
For initdb-option "--locale=" I found in the documentation "If this
option is not specified, the locale is inherited from the environment
that initdb runs in." So I presume that if I didn't explicitly set it to
anything other than my current environment, which I didn't, it should be
okay.
BTW: I've found on my linux distribution (SlackWare 7.x)
a wrong i18n
source file. After fixing this and compiling the new
locale evering
worked fine. It's corrected in the newer SlackWare.
I use SuSE 7.3, a german distro, so I cannot imagine that some serious
problem with german localization would have gone unnoticed. Of course I
did not use the PostgreSQL-Version provided with the distro - I got the
latest stable release 7.2.1 and compiled. So I guess that's not the
source of the problem.
Regards,
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2002-06-28 20:04:58 | Re: [HACKERS] Can't read archives anymore :-( |
Previous Message | Jason Earl | 2002-06-28 19:21:30 | Re: serial columns & loads misfeature? |