Message-ID: <1279.219.65.226.152.1054079874.squirrel@mail.trade-india.com>
Date: Wed, 28 May 2003 05:27:54 +0530 (IST)
Subject: Re: Getting rid of accents..
From: <mallah@trade-india.com>
To: <barwick@gmx.net>, <rlucas@tercent.net>
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>
Importance: Normal
Cc: <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


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/