Re: Getting rid of accents..

Thanks Ian ,

Indeed its the simplest/easiest solution to this problem i feel.
i did tried to_ascii function but was not specifying 'LATIN1'

do i was getting error

tradein_clients=# SELECT to_ascii('BÂLÂ MORGHÂB' );
ERROR: pg_to_ascii(): unsupported encoding from SQL_ASCII

would u like to explain it ?

Then i created a new database in latin1 encoding loaded the data
used to_ascii to convert , copied the data to new file and reloaded
back to original database ;-) .oO (tiring )

Lucas Thanks for that perl stuff too i will use it in some program
that stuffs arbitary text into database.

Regds
Mallah.

> 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
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off
> all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/