Copying into Unicode - Correcting Errors

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Copying into Unicode - Correcting Errors
Date: 2004-11-23 23:56:59
Message-ID: BDC90E4B.4D934%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

I need to import a file into a Unicode database.

I am getting an error:

ERROR: Unicode characters greater than or equal to 0x10000 are not
supported
CONTEXT: COPY mailing_list_entry, line 30928, column first_last_name:
"Ver?nica"

The source file came from pg_dump... Is there a way I can easily find rows
like this in the database so I can remove them before I export->import?

It looks like the source database has a lot of garbage in it... I guess I'm
asking if there is an 'easy' way to identify the rows that have issues so I
can deal with them... The table has 400,000 rows so locating them by hand is
not desirable.

I am running on 8.0b5 on MacOS X.

Thanks,
Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-24 00:01:39 Re: Regexp matching: bug or operator error?
Previous Message Thomas Hallgren 2004-11-23 23:41:26 Re: Regexp matching: bug or operator error?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2004-11-24 05:15:32 Re: [JDBC] Strange server error with current 8.0beta driver
Previous Message Tom Lane 2004-11-23 15:48:09 Re: When running with autocommit false only the first BEGIN