Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: GeoffreyDate: 2005-03-30 18:57:50
Subject: Re: rpm install issues - RHE3
Previous:From: Chris JensenDate: 2005-03-30 18:07:23
Subject: rpm install issues - RHE3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group