Thread: ilike and umlaut

ilike and umlaut

From
simon
Date:
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@wyona.com
Wyona Inc.  -   Open Source Content Management   -   Apache Lenya
http://www.wyona.com                      http://lenya.apache.org