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. :)
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Robert Strötgen mailto:[EMAIL PROTECTED] http://www.stroetgen.de/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
