Re: how to ignore accents? - Mailing list pgsql-novice

From Jaime Casanova
Subject Re: how to ignore accents?
Date
Msg-id c2d9e70e0503301923300469d6@mail.gmail.com
Whole thread Raw
In response to Re: how to ignore accents?  (Ennio-Sr <nasr.laili@tin.it>)
Responses Re: how to ignore accents?
List pgsql-novice
On Thu, 31 Mar 2005 02:01:45 +0200, Ennio-Sr <nasr.laili@tin.it> wrote:
> * Celia McInnis <celia@drmath.ca> [300305, 12:29]:
> > I have French text with accents in it and would rather (for search
> purposes)
> > be able to search for things with the accents removed. Is there any
> builtin
> > postgres function which will do this?
> >
> > Here is the format of some accented (French) words in my database:
> >
> > fran\347ais caf\351 t\364\t br\373le r\352ver \342nes b\350gues
> >
> > which I want to be able to search for as:
> >
> > francais cafe tot brule rever anes begues
> >
> > Celia
> >
>
> Hi Celia,
>
> I'm not an expert, but I'm afraid it's not possible to do that (and I'd
> be glad if somebody came out saying I'm wrong as I've the same problem).
>
If you are using LATIN1, LATIN2, LATIN9, or WIN1250 encoding i suppose
you can use the to_ascii() function.

regards,
Jaime Casanova

pgsql-novice by date:

Previous
From: Noel Faux
Date:
Subject: Loss of data and info from system tables!!
Next
From: Michael Fuhr
Date:
Subject: Re: Loss of data and info from system tables!!