Re: convert accented character to base character

On 06/28/10 8:22 AM, Neubert Joachim wrote:
>
> I want to convert accented characters to the according base character, 
> e.g. "Ü" or "Ú" to "U".
>
> Is there a way to do this with pgsql functions?
>
>


translate(somestring, 'ÙÚÛÜŨŪŬŮŰŲùúûüũūŭůűų', 'UUUUUUUUUUuuuuuuuuuu')

of course, expand those with all the other characters you want translated.