Обсуждение: 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.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
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
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