Postgres Pro
Downloads
Home   >   mailing lists

how to ignore invalid byte sequence for encoding without using sql_ascii? - Mailing list pgsql-general

From detrox@gmail.com
Subject how to ignore invalid byte sequence for encoding without using sql_ascii?
Date
Msg-id 1190885307.501885.243420@w3g2000hsg.googlegroups.com
Whole thread Raw
Responses Re: how to ignore invalid byte sequence for encoding without using sql_ascii?
List pgsql-general
Tree view 
I am now importing the dump file of wikipedia into my postgresql using
maintains/importDump.php. It fails on 'ERROR: invalid byte sequence
for encoding UTF-8'. Is there any way to let pgsql just ignore the
invalid characters ( i mean that drop the invalid ones ), that the
script will keep going without die on this error.

I know that i can using sql_ascii or even modify the importDump.php,
but those are not so easy to do as i thought.

thanks for help

pgsql-general by date:

Previous
From: "paul.dorman"
Date:
Subject: Re: DAGs and recursive queries
Next
From: "olivier.scalbert@algosyn.com"
Date:
Subject: importing large files