Postgres Pro
Downloads
Home   >   mailing lists

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

From Sam Mason
Subject Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Date
Msg-id 20090802193533.GX5407@samason.me.uk
Whole thread Raw
In response to character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"  (Andreas Kalsch <andreaskalsch@gmx.de>)
List pgsql-general
Tree view 
On Sun, Aug 02, 2009 at 08:45:52PM +0200, Andreas Kalsch wrote:
> Problem: Users will enter _any_ characters in my application and an
> error really doesn't help in this case.

Then why don't you stop converting to LATIN2?

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

It would be easy to write a regex to strip out the invalid characters if
that's what you want.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Andreas Kalsch
Date:
Subject: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Next
From: Dennis Gearon
Date:
Subject: Use of Postgres in REST/JSON with BLOBS