Re: LATIN2 and wrong upper() and lower() functions output - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: LATIN2 and wrong upper() and lower() functions output
Date
Msg-id Pine.LNX.4.30.0103301705340.1063-100000@peter.localdomain
Whole thread Raw
In response to LATIN2 and wrong upper() and lower() functions output  (Robert Gaszewski <graszew@poland.com>)
List pgsql-bugs
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/

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: I can't initialize
Next
From: Tom Lane
Date:
Subject: Re: BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.