I fond a problem at the RC1 of PostgreSQL (W32 - Version) When you use the UPPER or LOWER function with German letters (ä,ö,ü) this letters stay in lower/upper case. You can reproduce this error with this simple examples:
select upper('ü'); select upper('Tüte'); Test ID | sText ------------------- 1 | TÜTE 2 | EIMER select * from Test where sText = upper('tüte'); 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 Graf-Galen-Str. 17 59269 Beckum Tel.: +49 (0)2525 99 2076 Fax.: +49 (0)2525 99 2100 mailto:[EMAIL PROTECTED] http://www.polysius.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html