German "umlaut insensitive" query

From: Robert Strötgen <robert(at)stroetgen(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: German "umlaut insensitive" query
Date: 2004-09-01 14:01:43
Message-ID: 4135D647.4060203@stroetgen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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:robert(at)stroetgen(dot)de http://www.stroetgen.de/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-09-01 14:19:54 Re: casting BOOL to somthng
Previous Message Geoffrey 2004-09-01 10:25:30 Re: casting BOOL to somthng