Skip site navigation (1) Skip section navigation (2)

Re: Seaching with and without diacritical marks

From: Mike G <mike(at)thegodshalls(dot)com>
To: Ullrich Ralf <Ullrich(at)iai(dot)spk-berlin(dot)de>
Cc: "Pgsql-Novice (E-Mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Seaching with and without diacritical marks
Date: 2004-07-14 01:45:21
Message-ID: 20040714014521.GC3003@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novice
Automatically I don't believe so. 

You can modify your queries though.

IF default search returns 0 records then 
SET CLIENT_ENCODING TO 'some_other_encodin';
SELECT.....
END IF;

Maybe search for those special characters before issuing a SELECT statement.

HTH.

On Tue, Jul 13, 2004 at 02:20:48PM +0200, Ullrich Ralf wrote:
> Hello,
> 
> I have a multilingual portal running on PostgreSQL 7.4.2.
> My clients come from spain,portugal, latin america and germany (mainly). 
> The main feature of the site is a search engine that retrieves bibliographic data, which is stored in 
> my database (unicode!) with diacritical marks (e.g. Panamá,América); when users enter their search terms with diacritical marks postgres will find the requested records, but if a german user enter Panama or America (without diacritical marks), the  search fails. 
> Is there any extension for postgres that allows for both modes of searching on the same data?
> 
> Yours,
> 
> Ralf Ullrich
> 
> ______________________
> Ralf Ullrich, M.A.
> Virtuelle Fachbibliothek
> Ibero-Amerikanisches Institut
> Preußischer Kulturbesitz
> Potsdamer Str. 37			
> D-10785 Berlin
> Germany				
> Phone: +49 +30 266-2512
> Fax: +49 +30 266-2503
> E-Mail: ullrich(at)iai(dot)spk-berlin(dot)de
> http://www.iai.spk-berlin.de
> ______________________
> 
> 

Content-Description: Ullrich Ralf.vcf

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


In response to

pgsql-novice by date

Next:From: Marie-Lise VAUTIERDate: 2004-07-14 09:56:31
Subject: installation of postgis with red hat 9
Previous:From: Eduardo Vázquez RodríguezDate: 2004-07-13 19:00:16
Subject: Re: Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group