Hi!
-----Ursprüngliche Nachricht-----
Von: Thomas Beutin
Gesendet: Fr 28.06.2002 19:43
An: pgsql-general@postgresql.org
Cc:
Betreff: Re: [GENERAL] One source of constant annoyance
identified
> Environment-variables RC_LANG/LC_CTYPE are set to de_DE@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@euro.
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