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, [EMAIL PROTECTED] 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
> [EMAIL PROTECTED]
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 2: you
> can get off
> all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
