Holger Klawitter wrote: > I have checked with Java (toUpperCase()) and C (see attached program, > might help others) that my locale is working, but postgres (initdb > and postmaster running with LANG=de_DE.utf8, -E UNICODE) still > insists that upper('ä') equals 'ä'. What else can be wrong? PostgreSQL, case conversion, and Unicode don't work together. Pick any two. :-) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html