Обсуждение: BUG #1557: UPPER() and LOWER() do not return the right characters

Поиск
Список
Период
Сортировка

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

От
"Staffan Sandberg"
Дата:
The following bug has been logged online:

Bug reference:      1557
Logged by:          Staffan Sandberg
Email address:      staffan.sandberg@fhd.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

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

От
"John Hansen"
Дата:
Try the replacement upper/lower functions that I wrote:

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

Kind regards,

John Hansen

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

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

От
"John Hansen"
Дата:
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@dohle.com.scan on 27/03/2005 8:09 PM
            The e-mail system was unable to deliver the message, but did no=
t 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@geeknet.com.a=
u>... 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=20

Kind regards,

John Hansen

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