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:
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>...
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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Staffan Sandberg
> Sent: Tuesday, March 22, 2005 8:28 PM
> To: pgsql-bugs@postgresql.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: [EMAIL PROTECTED]
> 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
>
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
