> I tried to migrate a UTF-8 database with Japanese content from Postgresql
> 7.1.3 to Postgresql 7.2 unsucessfully.
> I made a pg_dump of the 7.1.3 database and tried to upload it in 7.2.
> Error message was "Invalid Unicode character sequence found".
> I tried to upload data in a fresh PostgreSQL 7.1.3 database and everything
> worked OK. The problem can be reproduced on PostgreSQL 7.2.
> Do not hesitate to ask me for a pg_dump of the involved tables. I cannot
> submit them on the list for privacy reasons. Thanks for your help.
I have received the test data and got:
psql:dump_error.sql:40: ERROR: copy: line 1, Invalid UNICODE character sequence found (0xe38227)
The error messages shows your data contains an invalid UTF-8 character
sequence. The first byte (e8) expects the UTF-8 sequence consists of 3
bytes, each of 8th bit on. However the third byte is 0x27, apparently
it does not satisfy the requirement. Check your data.
In response to
pgsql-hackers by date
|Next:||From: Christopher Kings-Lynne||Date: 2002-02-20 02:41:32|
|Subject: Re: alter table drop column status |
|Previous:||From: Philip Warner||Date: 2002-02-19 23:11:59|
|Subject: Re: pg_dump: use ALTER TABLE for PKs|
pgsql-odbc by date
|Next:||From: kuolung lin||Date: 2002-02-20 02:28:20|
|Previous:||From: Kristis Makris||Date: 2002-02-19 23:54:48|
|Subject: Are multiple selects of the same field allowed usingCRecordset::GetFieldValue() ?|