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

BUG #3737: lower/upper fails to match extended chars in LATIN1

From: "Jonas Forsman" <jonas(at)axier(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3737: lower/upper fails to match extended chars in LATIN1
Date: 2007-11-09 16:23:04
Message-ID: 200711091623.lA9GN4V5055408@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3737
Logged by:          Jonas Forsman
Email address:      jonas(at)axier(dot)org
PostgreSQL version: 8.1.10
Operating system:   Ubuntu 6.06 LTS
Description:        lower/upper fails to match extended chars in  LATIN1
Details: 

Try:
select * from table where lower(address) like '%%'

This select fails to find addresses including capital  and similars in
LATIN1 (like , , ). 

The same bug is valid for upper.

Responses

pgsql-bugs by date

Next:From: Chris VickeryDate: 2007-11-09 16:40:59
Subject: BUG #3738: psql crashes on exit.
Previous:From: DerekDate: 2007-11-09 16:18:10
Subject: BUG #3736: server cannot listen

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