Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

[GENERAL] how to ignore invalid byte sequence for encoding without using sql_ascii?

From: <detrox(at)gmail.com>
Date: Thu Sep 27 2007 - 05:28:27 EDT


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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
Received on Mon Oct 1 13:33:22 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 12:00:20 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library