Re: unaccent as stored procedure?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: Stephen Woodbridge <woodbri(at)swoodbridge(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unaccent as stored procedure?
Date: 2006-12-05 10:50:53
Message-ID: 45754F0D.5010700@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephen Woodbridge a écrit :
> Or maybe there is another general solution that I am no aware of.

If you just want to remove accents from your string, you can
use :
to_ascii(convert(<mystring>, 'LATIN9'), 'LATIN9')
It works very well AFAIAC.

(tip given on this list)

--
Arnaud

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bernd Helmle 2006-12-05 10:57:39 Re: How to speed up Exclusive Locking
Previous Message Oleg Bartunov 2006-12-05 10:45:22 Re: unaccent as stored procedure?