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

Re: BUG #1557: UPPER() and LOWER() do not return the right characters

From: "John Hansen" <john(at)geeknet(dot)com(dot)au>
To: "Staffan Sandberg" <staffan(dot)sandberg(at)fhd(dot)se>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1557: UPPER() and LOWER() do not return the right characters
Date: 2005-03-27 10:12:44
Message-ID: 5066E5A966339E42AA04BA10BA706AE56281@rodrick.geeknet.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
Also,... Could the user responsible for this NDR:

Your message did not reach some or all of the intended recipients.

      Subject:	Re: [BUGS] BUG #1557: UPPER() and LOWER() do not return the right characters
      Sent:	27/03/2005 8:07 PM

The following recipient(s) could not be reached:

      akruemmel(at)dohle(dot)com(dot)scan on 27/03/2005 8:09 PM
            The e-mail system was unable to deliver the message, but did not report a specific reason.  Check the address and try again.  If it still fails, contact your system administrator.
            < majestix.dohle.com #5.0.0 SMTP; 550 5.0.0 <john(at)geeknet(dot)com(dot)au>... We don't accept mail from spammers>

Please see to it that they update their anti-spam rules.
I recent the implication of being a spammer.


... John


Try the replacement upper/lower functions that I wrote:

http://archives.postgresql.org/pgsql-hackers/2005-02/msg00102.php 

Kind regards,

John Hansen

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org 
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Staffan Sandberg
> Sent: Tuesday, March 22, 2005 8:28 PM
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] BUG #1557: UPPER() and LOWER() do not return 
> the right characters
> 
> 
> The following bug has been logged online:
> 
> Bug reference:      1557
> Logged by:          Staffan Sandberg
> Email address:      staffan(dot)sandberg(at)fhd(dot)se
> PostgreSQL version: 7.4.6-1.FC2.2
> Operating system:   Fedora Core 2
> Description:        UPPER() and LOWER() do not return the 
> right characters
> Details: 
> 
> Hi,
> 
> I am using a PostgreSQL DB with the LATIN1 (ISO-8859-1) 
> character encoding.
> When using the UPPER() or LOWER() functions on any of our 
> swedish specific characters the returned character is never 
> transformed to the desired case.
> The functions only return the same character as the input, 
> disregarding of the input character's case.
> 
> E.g: LOWER('Ã-') should return 'ö' but instead 'Ã-' is returned.
> 
> The concerned characters are:
> LOWER     UPPER
> Ã¥         Ã...
> ä         Ã"
> ö         Ã-
> 
> To solve the problem I am now forced to use the REPLACE() 
> function for these three characters, hence it would be more 
> convinient if the LOWER() and
> UPPER() functions worked properly.
> 
> Please make a comment on my report!
> Kind regards,
> Staffan Sandberg
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2005-03-27 16:23:45
Subject: Re: BUG #1564: special Character OleDB
Previous:From: John HansenDate: 2005-03-27 10:06:40
Subject: Re: BUG #1557: UPPER() and LOWER() do not return the right characters

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