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



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