Re: unaccent as stored procedure? - Mailing list pgsql-general

From Arnaud Lesauvage
Subject Re: unaccent as stored procedure?
Date
Msg-id 45754F0D.5010700@freesurf.fr
Whole thread Raw
In response to unaccent as stored procedure?  (Stephen Woodbridge <woodbri@swoodbridge.com>)
List 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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: unaccent as stored procedure?
Next
From: Bernd Helmle
Date:
Subject: Re: How to speed up Exclusive Locking