Re: [SQL] Getting rid of accents..

[Randall Lucas]

Hi Mallah,

I had this problem once, and put together this bunch of regexes.  It's 
by no means optimal, but should solve 90% and would easily be adapted 
into a plperl function.

Begin perl:
  $value =~ s/[\xc0-\xc6]/A/g;
  $value =~ s/[\xc7]/C/g;
  $value =~ s/[\xc8-\xcb]/E/g;
  $value =~ s/[\xcc-\xcf]/I/g;
  $value =~ s/[\xd1]/N/g;
  $value =~ s/[\xd2-\xd6\xd8]/O/g;
  $value =~ s/[\xd9-\xdc]/U/g;
  $value =~ s/[\xdd]/Y/g;
  $value =~ s/[\xe0-\xe6]/a/g;
  $value =~ s/[\xe7]/c/g;
  $value =~ s/[\xe8-\xeb]/e/g;
  $value =~ s/[\xec-\xef]/i/g;
  $value =~ s/[\xf1]/n/g;
  $value =~ s/[\xf2-\xf6\xd8]/o/g;
  $value =~ s/[\xf9-\xfc]/u/g;
  $value =~ s/[\xfd\xff]/y/g;


On Tuesday, May 27, 2003, at 04:55 PM, <[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



Regds
Mallah.
-----------------------------------------
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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])