Re: Getting rid of accents..

From: Ian Barwick <barwick(at)gmx(dot)net>
To: <mallah(at)trade-india(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Getting rid of accents..
Date: 2003-05-27 22:15:02
Message-ID: 200305280015.02483.barwick@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tuesday 27 May 2003 22:55, mallah(at)trade-india(dot)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(at)gmx(dot)net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Forest Wilkinson 2003-05-27 22:53:26 Empty queries guaranteed to work?
Previous Message Randall Lucas 2003-05-27 21:52:02 Re: Getting rid of accents..