One solution:
select replace( replace( replace( replace( 'Test ä ö ü ß', 'ä','ae'), 'ö','oe' ), 'ü','ue'), 'ß','ss' );
replace ------------------ Test ae oe ue ss
If you also have upcase-characters, you have to extend the statement.
Robert Strötgen schrieb:
I want to query words with German "umlauts" (special characters) with and without normalization. I want to find "grün" (green) written "gruen" as well.
Using "LIKE" with locale de_DE.iso88591 or .utf-8 does not help (Locale support should affect "LIKE",
http://www.postgresql.org/docs/7.3/static/charset.html#AEN21761).
Any Idea how to solve this? Define a special Operator? Has anyone already done this before?
I am using PostgreSQL 7.3.2 on Linux.
TIA, Robert Strötgen. :)
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
