Postgres Pro
Downloads
Home   >   mailing lists

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

From Neubert Joachim
Subject convert accented character to base character
Date
Msg-id 3A59BB6451C972429019B12996F92DAD02E4D47B@frodo.zbw-nett.zbw-kiel.de
Whole thread Raw
Responses Re: convert accented character to base character  (Thom Brown <thombrown@gmail.com>)
Re: convert accented character to base character  (John R Pierce <pierce@hogranch.com>)
Re: convert accented character to base character  (Mathieu De Zutter <mathieu@dezutter.org>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to log query parameters instead of variables with log_min_duration_statement
Next
From: Max Williams
Date:
Subject: Re: How to log query parameters instead of variables with log_min_duration_statement