Hi Lutz,

> I am experiencing big trouble while trying to solve the seemingly
> simple problem of a case-insensitive search like select * from x
> where upper(fieldname)=upper(:searchstring). what makes this task
> difficult are the german umlauts.

A quick and easy solution should be to upper the searchstring with
java.lang.String's toUpperCase() method. In fact i've sucessfully used
this method in some Hibernate projects already.
http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html#toUpperCase(java.util.Locale)

Michael