Skip site navigation (1) Skip section navigation (2)

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

From: Nishad Prakash <prakashn(at)uci(dot)edu>
To: Pache(at)hub(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)
Date: 2000-10-17 20:51:09
Message-ID: Pine.GSO.4.21.0010171340060.25475-100000@e4e.oac.uci.edu (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Tue, 17 Oct 2000 pgsql-bugs(at)postgresql(dot)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



In response to

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2000-10-17 22:57:26
Subject: Re: length coerce for bpchar is broken since 7.0
Previous:From: Tom LaneDate: 2000-10-17 20:43:41
Subject: Re: DROP VIEW code question

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-10-17 21:06:05
Subject: Re: Field Separator setting not used.
Previous:From: pgsql-bugsDate: 2000-10-17 19:58:27
Subject: UPPER and LOWER dosen't work correctly on special caracters (umlauts)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group