Need magic to clean strings from unconvertible UTF8

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Need magic to clean strings from unconvertible UTF8
Date: 2010-11-07 04:35:08
Message-ID: 4CD62C7C.4040106@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

somehow there have unconvertible characters sneaked into my DB.
Very probaply they came in via Imports from MS-Access.

Access doesn't complain but when I try to export stuff with pgAdmin to
csv I get an error that some char is not representable in the local charset.

I can find the problematic rows.
How could I delete every char in a string that can't be converted to
WIN1252?

Regards
Andreas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-11-07 05:54:32 Re: Need magic to clean strings from unconvertible UTF8
Previous Message John R Pierce 2010-11-07 03:43:08 Re: Libpq is very slow on windows but fast on linux.