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
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? |
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 |