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