From: mallah@trade-india.com
To: barwick@gmx.net
To: rlucas@tercent.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Getting rid of accents..
Date: Wed, 28 May 2003 05:27:54 +0530 (IST)
Message-ID: <1279.219.65.226.152.1054079874.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <200305280015.02483.barwick@gmx.net>
References: <1140.219.65.226.152.1054068906.squirrel@mail.trade-india.com>
<200305280015.02483.barwick@gmx.net>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, barwick@gmx.net, rlucas@tercent.net
Subject: Re: Getting rid of accents..
In-Reply-To: <1279.219.65.226.152.1054079874.squirrel@mail.trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox