Andreas writes:
> I can find the problematic rows.
> How could I delete every char in a string that can't be converted to
> WIN1252?
http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_1.html
http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html
That's using an
Am 07.11.2010 06:54, schrieb John R Pierce:
On 11/06/10 9:35 PM, Andreas wrote:
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
On 11/06/10 9:35 PM, Andreas wrote:
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 lo
