Re: how to ignore accents?

* Jaime Casanova <systemguards(at)gmail(dot)com> [300305, 22:23]:
> On Thu, 31 Mar 2005 02:01:45 +0200, Ennio-Sr <nasr(dot)laili(at)tin(dot)it> wrote:
> > * Celia McInnis <celia(at)drmath(dot)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
Hi Jaime,
Just for the records:
I tried both Michael's unaccent() and to_ascii() and found that
to_asci() also works, but 'traces' unaccented vowels as well.
Thanks for your suggestion, regards,
Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]