Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date
Msg-id E0010333-17A0-4952-9388-A046C04896F7@elevated-dev.com
Whole thread Raw
In response to Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92  (Prasanth Reddy <dbadmin@nqadmin.com>)
List pgsql-admin
Tree view 
On Aug 11, 2015, at 8:59 AM, Prasanth Reddy <dbadmin@nqadmin.com> wrote:
>
> The server uses SQL_ASCII encoding and the
> client encoding is UTF8. There are some invalid characters in the database but this has not caused a problem in the
currentversion or 9.3 (tried a restore in 9.3 and the application works fine). 

Later versions of PostgreSQL do better checking of UTF-8, and disallow invalid sequences.

You're going to have to straighten out your encoding conflicts.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

pgsql-admin by date:

Previous
From: Prasanth Reddy
Date:
Subject: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Next
From: Tom Lane
Date:
Subject: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92