character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2" - Mailing list pgsql-general

From Andreas Kalsch
Subject character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Date
Msg-id 4A75DEE0.7040501@gmx.de
Whole thread Raw
Responses Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
The function "convert_to(string text, dest_encoding name)" will throw an
error and so break my application when not supported characters are
included in the unicode string.
So what can I do
- to filter characters out which have no counterpart in the latin codesets
- or to simple ignore wrong characters?

Problem: Users will enter _any_ characters in my application and an
error really doesn't help in this case.

What I am searching for is a function to undiacritic special letters to
simple ones.

There is provided an example -
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Diacritic_removing
- which will not work because of the error, when I put _any_ valid UTF8
character to the functions.

Best,

Andi

pgsql-general by date:

Previous
From: Denis BUCHER
Date:
Subject: Re: How to execute external script from a TRIGGER or FUNCTION ?
Next
From: Sam Mason
Date:
Subject: Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"