Re: Locale settings

"Tille, Andreas" <TilleA@rki.de> writes:
> 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@euro
>          LC_ALL=de_DE@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.

You did not say what platform you are on, but I suspect you are getting
bit by 7.1's nonportable assumptions about behavior of localeconv().
These garbage locale strings could have come from 7.1's assumption that
a string returned by localeconv() will still be valid after changing
settings with setlocale().

Try 7.2.

            regards, tom lane