Re: Seaching with and without diacritical marks

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