Problem with Upper/Lower Function - Mailing list pgsql-bugs

From Hesse, Hendrik
Subject Problem with Upper/Lower Function
Date
Msg-id 16353A2D55ED724AB7B84A5FBACED4652AF431@kp07s112.kp.thyssenkrupp.com
Whole thread Raw
Responses Re: Problem with Upper/Lower Function  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Problem with Upper/Lower Function  (Roland Volkmann <roland.volkmann@gmx.de>)
List pgsql-bugs
I fond a problem at the RC1 of PostgreSQL (W32 - Version)

When you use the UPPER or LOWER function with German letters (=E4,=F6,=FC) =
this
letters stay in lower/upper case.
You can reproduce this error with this simple examples:

select upper('=FC');
select upper('T=FCte');

Test
ID    |   sText=20=20=20
-------------------
1        |   T=DCTE
2    |   EIMER

select * from Test where sText =3D upper('t=FCte');


I can reproduce this problem in several computers.




Mit freundlichen Gruessen / with best regards

Hendrik Hesse
--------------------------------------------------
P O L Y S I U S   AG
Abt. 164=20
Graf-Galen-Str. 17
59269 Beckum
Tel.:    +49 (0)2525 99 2076
Fax.:    +49 (0)2525 99 2100
mailto:Hendrik.Hesse@thyssenkrupp.com
http://www.polysius.com

pgsql-bugs by date:

Previous
From: "Belbin, Peter"
Date:
Subject: Re: solaris 10 with gcc 3.3.2
Next
From: Christoph Haller
Date:
Subject: 8.0.0rc1 on hppa2.0w-hp-hpux11.00