Postgres Pro
Downloads
Home   >   mailing lists

Re: convert accented character to base character - Mailing list pgsql-general

From John R Pierce
Subject Re: convert accented character to base character
Date
Msg-id 4C28C26D.7000802@hogranch.com
Whole thread Raw
In response to convert accented character to base character  ("Neubert Joachim" <J.Neubert@zbw.eu>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: convert accented character to base character
Next
From: "dario.ber@libero.it"
Date:
Subject: postgres user password: Log on failure