UPPER and LOWER dosen't work correctly on special caracters (umlauts)

On Tue, 17 Oct 2000 pgsql-bugs@postgresql.org wrote:

Gert (Pache) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
UPPER and LOWER dosen't work correctly on special caracters (umlauts)

Long Description
The Upper- and the lower function don't convert the german umlauts (���.���.���.)
but leave them in their original condition

Sample Code

No file was uploaded with this report

You can make this work with some help from your OS. Have your locale set
correctly to recognize non-ascii characters when postmaster starts. I did
it by setting LC_CTYPE to iso_8859_1 in the postgres superuser's shell
initialization file. Note that this won't work unless the locale is
actually available on your machine; you can't just type the same thing I
did and hope for the best.

If it helps, this is from the postgres superuser's shell at our site:
[1:42pm] /data/postgres> uname -a
SunOS ptolemy.tlg.uci.edu 5.6 Generic_105181-08 sun4u sparc SUNW,Ultra-5_10

[1:43pm] /data/postgres> locale
LANG=
LC_CTYPE=iso_8859_1
LC_NUMERIC="C"
LC_TIME="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_MESSAGES="C"
LC_ALL=

This is not a complete solution (collation is still incorrect) but it
should get you started. Hope it helps.

Nishad
--
"Underneath the concrete, the dream is still alive" -- Talking Heads

The Upper- and the lower function don't convert the german umlauts (�.�.�.) but leave them in their original condition

Gert (or anyone): what should the result be? I'm German-impaired, so
you'll need to be more specific. Did you compile with locale turned on?
Multi-byte character sets?? Which byte codes correspond to the lower-
and upper-case umlaut characters???

- Thomas

You need to enable locale support (see documentation).
Best regards
Rony