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


Tue, 17 Oct 2000 15:58:27 -0400 (EDT)
pgsql-bugs@postgresql.org
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



Tue, 17 Oct 2000 13:51:09 -0700 (PDT)
Nishad Prakash <prakashn@uci.edu>
Re: UPPER and LOWER dosen't work correctly on special caracters
	(umlauts)
> 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

Wed, 18 Oct 2000 05:18:08 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: UPPER and LOWER dosen't work correctly on special caracters
	(umlauts)
You need to enable locale support (see documentation).
Best regards
Rony

> -----Ursprï¿½ngliche Nachricht-----
> Von: pgsql-bugs-owner@hub.org [mailto:pgsql-bugs-owner@hub.org]Im
> Auftrag von pgsql-bugs@postgresql.org
> Gesendet: 17 paï¿½dziernika 2000 21:58
> An: pgsql-bugs@postgresql.org
> Betreff: [BUGS] UPPER and LOWER dosen't work correctly on special
> caracters (umlauts)
>
>
> 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
>


Wed, 18 Oct 2000 08:34:25 +0200
"Ronald Kuczek" <ronald@unix.breitenbach-it.de>
AW: UPPER and LOWER dosen't work correctly on special caracters
	(umlauts)