The following bug has been logged online:

Bug reference: 2540
Logged by: radoslaw wisniewski
Email address: radzimir (AT) freenet (DOT) de
PostgreSQL version: 8.1.4-2
Operating system: Linux
Description: function upper(..) and operator 'like' problem
Details:

function upper combined with like opertaor and german umlauts (db encoding
UTF8) fails.

Working example in some query:

select * from test where upper( name ) like upper('%Störk%')

Not working example:

select * from test where upper( name ) like '%STÖRK%'

function lower seems to have the same problem.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

radoslaw wisniewski wrote:
You have probably configured the wrong locale, but you have not given
nearly enough information to reproduce your problem.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq