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: (view raw or whole 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



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-2015 The PostgreSQL Global Development Group