Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group