On Aug 11, 2015, at 8:59 AM, Prasanth Reddy <dbadmin(at)nqadmin(dot)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 current version 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice