convert accented character to base character

Поиск
Список
Период
Сортировка
От Neubert Joachim
Тема convert accented character to base character
Дата
Msg-id 3A59BB6451C972429019B12996F92DAD02E4D47B@frodo.zbw-nett.zbw-kiel.de
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to log query parameters instead of variables with log_min_duration_statement
Следующее
От: Max Williams
Дата:
Сообщение: Re: How to log query parameters instead of variables with log_min_duration_statement