Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Date: 2009-08-03 20:27:31
Message-ID: 20090803202731.GF19615@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2009-08-03 20:35:28 iGen with PostgreSQL 8.4 on Sun Fire X4140
Previous Message Pavel Stehule 2009-08-03 19:33:05 Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"