how to ignore accents? - Mailing list pgsql-novice

From Celia McInnis
Subject how to ignore accents?
Date
Msg-id 20050330181358.M91479@drmath.ca
Whole thread Raw
Responses Re: how to ignore accents?
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Chris Jensen
Date:
Subject: rpm install issues - RHE3
Next
From: Geoffrey
Date:
Subject: Re: rpm install issues - RHE3