Error while loading sql file

Started by Adarsh Sharmaover 14 years ago1 messagesgeneral
Jump to latest
#1Adarsh Sharma
adarsh.sharma@orkash.com

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