The following bug has been logged online:
Bug reference: 3737
Logged by: Jonas Forsman
Email address: jonas@axier.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.