Postgres Pro
Downloads
Home   >   mailing lists

German "umlaut insensitive" query - Mailing list pgsql-sql

From Robert Strötgen
Subject German "umlaut insensitive" query
Date
Msg-id 4135D647.4060203@stroetgen.de
Whole thread Raw
Responses Re: German "umlaut insensitive" query  (Michael Kleiser <mkl@webde-ag.de>)
List pgsql-sql
Tree view 
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@stroetgen.de
      http://www.stroetgen.de/
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-sql by date:

Previous
From: Geoffrey
Date:
Subject: Re: casting BOOL to somthng
Next
From: Tom Lane
Date:
Subject: Re: casting BOOL to somthng