Re: LATIN2 and wrong upper() and lower() functions output

Robert Gaszewski writes:

> When I try SELECT UPPER('some_text_with_polish_national_chars');
> polish chars are still in lower case but others (abcd...wxyz) are
> in upper case.

> I compiled PostgreSQL with --enable-multibyte and
> --enable-unicode-conversion.

Case conversion and ordering are controlled by *locale*, not multibyte.
You need to configure with --enable-locale and set the appropriate LC_*
variables.

http://www.postgresql.org/devel-corner/docs/postgres/charset.html#LOCALE

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/