X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C41575E3F15 for ; Wed, 1 Sep 2004 11:01:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81644-02 for ; Wed, 1 Sep 2004 14:01:47 +0000 (GMT) Received: from onos.eremos.boltzendahl-stroetgen.de (a97.shuttle.de [194.95.224.97]) by svr1.postgresql.org (Postfix) with ESMTP id B698E5E4713 for ; Wed, 1 Sep 2004 11:01:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by onos.eremos.boltzendahl-stroetgen.de (Postfix) with ESMTP id 45C291AAF8 for ; Wed, 1 Sep 2004 16:01:45 +0200 (CEST) Received: from onos.eremos.boltzendahl-stroetgen.de (localhost [127.0.0.1]) by localhost (AvMailGate-2.0.2-8) id 04224-72DAB8F3; Wed, 01 Sep 2004 16:01:45 +0200 Received: from gorchfock.eremos.boltzendahl-stroetgen.de (gorchfock.eremos.boltzendahl-stroetgen.de [192.168.1.1]) by onos.eremos.boltzendahl-stroetgen.de (Postfix) with ESMTP id 15CC5116E6 for ; Wed, 1 Sep 2004 16:01:45 +0200 (CEST) Received: from gorchfock.eremos.boltzendahl-stroetgen.de ([192.168.1.1]) by gorchfock.eremos.boltzendahl-stroetgen.de with esmtp (Exim 4.41) id I3D8AX-0003V4-CX for pgsql-sql@postgresql.org; Wed, 01 Sep 2004 16:01:45 +0200 Message-ID: <4135D647.4060203@stroetgen.de> Date: Wed, 01 Sep 2004 16:01:43 +0200 From: =?ISO-8859-1?Q?Robert_Str=F6tgen?= User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: de, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: German "umlaut insensitive" query X-Enigmail-Version: 0.84.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-AntiVirus: checked by AntiVir MailGate (version: 2.0.2-8; AVE: 6.27.0.6; VDF: 6.27.0.43; host: onos) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/14 X-Sequence-Number: 18860 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/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~