hello all we are using psql 7.3.10 ILIKE seems not to work properly with german umlaut. i already saw some previous posts (http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php) about this problem and there seems to be a patch around that fixes the problem for LATIN5 but i didn't find any solution for UNICODE. does anybody know how to work around this problem or even has a real solution? any hint or help would be very much apretiated. thanks simon -- Simon Litwan simon.litwan@xxxxxxxxx Wyona Inc. - Open Source Content Management - Apache Lenya http://www.wyona.com http://lenya.apache.org