Bhajesh wrote:
My previous server database encoding was SQL_ASCII.i took the backup in
UTF8 encoding.when i was going to restore the backup in new server whose
encoding is UTF-8 it is throwing some error like "invalid UTF-8 byte
sequence detected near byte 0xa3".When i tried to restore same server then
also it is showing same error.I don't know why it is happening please help
me.
What commands exactly did you use to take the backup and to restore it?
It seems that even though you specified SQL_ASCII as the encoding in the
old database, you nevertheless stored non-ASCII characters in it. You
need to know what encoding was used to store them. Once you know that,
you can edit the backup dump (assuming you used pg_dump), and modify the
line that says "SET client_encoding = ..." to the correct encoding. You
can also use the iconv program to convert the dump from one encoding to
another.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
