Problem with Upper/Lower Function

From: "Hesse, Hendrik" <hendrik(dot)hesse(at)thyssenkrupp(dot)com>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with Upper/Lower Function
Date: 2004-12-16 15:41:43
Message-ID: 16353A2D55ED724AB7B84A5FBACED4652AF431@kp07s112.kp.thyssenkrupp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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:Hendrik(dot)Hesse(at)thyssenkrupp(dot)com
http://www.polysius.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2004-12-16 21:42:03 Re: BUG #1349: Gap in documentation - pg_dump
Previous Message Bruno Wolff III 2004-12-16 13:44:07 Re: BUG #1349: Gap in documentation - pg_dump