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

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Date: 2009-08-02 19:35:33
Message-ID: 20090802193533.GX5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2009-08-02 19:45:42 Use of Postgres in REST/JSON with BLOBS
Previous Message Andreas Kalsch 2009-08-02 18:45:52 character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"