Re: Getting rid of accents..

On Tuesday 27 May 2003 22:55, mallah@trade-india.com wrote:
> Is there any easy way for converting accented text to
> closest text  without accents in postgresql ?
>
> eg:
>
> BÂLÂ MORGHÂB  to  BALA MORGHAB

Have you looked at to_ascii()? Something along the lines of

select to_ascii('Â', 'LATIN1')


Ian Barwick
barwick@gmx.net