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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend