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

From Alvaro Herrera
Subject Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Date
Msg-id 20090803202731.GF19615@alvh.no-ip.org
Whole thread Raw
In response to character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"  (Andreas Kalsch <andreaskalsch@gmx.de>)
List pgsql-general
Andreas Kalsch wrote:
> 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?

Perhaps this is useful:

http://wiki.postgresql.org/wiki/Strip_accents_from_strings

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Next
From: Tom Lane
Date:
Subject: Re: how can i mark date function like iscachable