convert accented character to base character

From: "Neubert Joachim" <J(dot)Neubert(at)zbw(dot)eu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: convert accented character to base character
Date: 2010-06-28 15:22:19
Message-ID: 3A59BB6451C972429019B12996F92DAD02E4D47B@frodo.zbw-nett.zbw-kiel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

postgres=# select convert('Ü', 'UTF8', 'SQL_ASCII');

convert

----------

\303\234

did not work as I had hoped.

Any help would be appreciated -

Cheers, Joachim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Max Williams 2010-06-28 15:30:01 Re: How to log query parameters instead of variables with log_min_duration_statement
Previous Message Tom Lane 2010-06-28 14:28:16 Re: How to log query parameters instead of variables with log_min_duration_statement