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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: dbadmin(at)nqadmin(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: 2015-08-11 15:17:26
Message-ID: E0010333-17A0-4952-9388-A046C04896F7@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-08-11 15:18:14 Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Previous Message Prasanth Reddy 2015-08-11 14:59:54 Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92