Error while loading sql file - Mailing list pgsql-general

From Adarsh Sharma
Subject Error while loading sql file
Date
Msg-id 4EF820CA.8040506@orkash.com
Whole thread Raw
List pgsql-general
Dear all,

I am facing a unique issue when I try to load an sql into a postgresql database :-

ERROR:  invalid byte sequence for encoding "UTF8": 0xe32720
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".
ERROR:  invalid byte sequence for encoding "UTF8": 0xe32720
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".
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block

 I faced an issue some days ago & I solved the issue by the below command :

( http://blog.e-shell.org/134 )

ERROR:  invalid byte sequence for encoding "UTF8": 0xf36e2020
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".

cat backup.sql | recode iso-8859-1..u8 > backup.sql
But this time the byte sequence changes to Japanese , & I fail to solve the issue. Please let me know how to solve the issue as typing the error in Google shows only one link:


Thanks

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Error while loading sql file
Next
From: Alban Hertroys
Date:
Subject: Re: Error while loading sql file