Postgres Pro
Downloads
Home   >   mailing lists

Need magic to clean strings from unconvertible UTF8 - Mailing list pgsql-general

From Andreas
Subject Need magic to clean strings from unconvertible UTF8
Date
Msg-id 4CD62C7C.4040106@gmx.net
Whole thread Raw
Responses Re: Need magic to clean strings from unconvertible UTF8  (John R Pierce <pierce@hogranch.com>)
Re: Need magic to clean strings from unconvertible UTF8  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.
Next
From: John R Pierce
Date:
Subject: Re: Need magic to clean strings from unconvertible UTF8