how to ignore accents?

From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to ignore accents?
Date: 2005-03-30 18:29:58
Message-ID: 20050330181358.M91479@drmath.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Geoffrey 2005-03-30 18:57:50 Re: rpm install issues - RHE3
Previous Message Chris Jensen 2005-03-30 18:07:23 rpm install issues - RHE3