Have a look at translate(). It behaves like the unix command 'tr'.
Randall Lucas wrote: > > 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]) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
