Re: Searching accented words

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: João Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Searching accented words
Date: 2002-07-25 07:54:39
Message-ID: 20020725075439.GB11322@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 24, 2002 at 04:20:10PM -0300,
João Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br> wrote
a message of 29 lines which said:

> How can I perform a query that return the two rows, no
> matter I pass 'José' or 'Jose' as parameter?

A la Altavista, uh? I believe you have to write your own
function. Case-folding fuzzy matching rules are quite dependent on the
language (not on the script, we both use Latin-1, on the
language).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bjoern Metzdorf 2002-07-25 09:04:49 erserver
Previous Message Stephane Bortzmeyer 2002-07-25 07:53:02 Re: Searching accented words