BUG #2540: function upper(..) and operator 'like' problem

From: "radoslaw wisniewski" <radzimir(at)freenet(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2540: function upper(..) and operator 'like' problem
Date: 2006-07-20 13:26:49
Message-ID: 200607201326.k6KDQnx9062678@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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('%Strk%')

Not working example:

select * from test where upper( name ) like '%STRK%'

function lower seems to have the same problem.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message sma~~NRf!! 2006-07-20 19:54:09 5jWku@ `l / a` / N / y / st@LXv MLMMIZNOF
Previous Message Olavo Setubal 2006-07-20 12:41:40 Dúvidas sobre postGresSQL