Search Postgresql Archives

Re: error while trying to change the database encoding on a database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding.  They were created as SQL_ASCII and we
are changing them to UTF8.

When testing this Friday, I received the following error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5225; 0 16990 TABLE
DATA cust postgres
pg_restore: [archiver (db)] COPY failed: ERROR:  invalid byte sequence
for encoding "UTF8": 0xb0
HINT:  This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
CONTEXT:  COPY cust, line 778
                        ^^^^^^^ In the COPY command for that table.
I picked up ont that, but the dump is binary, thus I can not view the
actual code.

Actually you can :) I should have mentioned it before. You can have pg_restore restore to a file instead of a database by using the -f switch. When you do that it creates plain text output. You could restore the entire dump to the file or use the -t switch to get only the table you need.

Thanks for the suggestion. As it stands, we are getting different errors for different hex characters, thus the solution we need is the ability to identify the characters that won't convert from SQL_ASCII to UTF8. Is there a resource that would identify these characters?


Is there any easy way to figure out which record caused this error?

Thanks.

--
Until later, Geoffrey
--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson





--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux