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.