Re: BUG #14197: ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8"

Hi,

The migration was successful .

• while creating backup for the database we used postgresql 7 version .

• While restoring the same backup using postgreSQL 9.5.3 we are facing the mentioned problem.

• ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8" is thrown in postgreSQL 9.5.3 .
Please help me out to resolve this error.

Regards,
Bhavani

From: bhavani, sheri (Cognizant)
Sent: Friday, June 17, 2016 10:27 AM
To: Bhanu Priya (Cognizant) (Bhanu(dot)Priya3(at)cognizant(dot)com)
Subject: FW: [BUGS] BUG #14197: ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8"

From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Friday, June 17, 2016 10:21 AM
To: bhavani, sheri (Cognizant)
Subject: Re: [BUGS] BUG #14197: ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8"

Please direct replies to the list.

On Friday, June 17, 2016, <sheri(dot)bhavani(at)cognizant(dot)com<mailto:sheri(dot)bhavani(at)cognizant(dot)com>> wrote:
Hi,

The migration was successful .

• while creating backup for the database we used postgresql 7 version .

• While restoring the same backup using postgreSQL 9.5.3 we are facing the mentioned problem.

• ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8" is thrown in postgreSQL 9.5.3 .
Please help me out to resolve this error.

Regards,
Bhavani

From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com<javascript:_e(%7B%7D,'cvml','david(dot)g(dot)johnston(at)gmail(dot)com');>]
Sent: Thursday, June 16, 2016 6:58 PM
To: bhavani, sheri (Cognizant)
Cc: pgsql-bugs(at)postgresql(dot)org<javascript:_e(%7B%7D,'cvml','pgsql-bugs(at)postgresql(dot)org');>
Subject: Re: [BUGS] BUG #14197: ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8"

On Thu, Jun 16, 2016 at 8:22 AM, <sheri(dot)bhavani(at)cognizant(dot)com<javascript:_e(%7B%7D,'cvml','sheri(dot)bhavani(at)cognizant(dot)com');>> wrote:
The following bug has been logged on the website:

Bug reference: 14197
Logged by: bhavani sheri
Email address: sheri(dot)bhavani(at)cognizant(dot)com<javascript:_e(%7B%7D,'cvml','sheri(dot)bhavani(at)cognizant(dot)com');>
PostgreSQL version: 9.5.3
Operating system: Windows7
Description:

I have migrated from postgreSQL 7 to postgreSQL 9.5.3 and thus getting this
error.Please help me to resolve it.

I'd start with:

Google: ​
fixing character with byte sequence postgresql

​You use the past tense here "I have migrated" - did the migration succeed and you are getting errors during normal operations or has some aspect of your migration failed?

David J.​

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.