Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92

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