Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZPB3g-0008AM-Pi for pgsql-admin@arkaria.postgresql.org; Tue, 11 Aug 2015 15:01:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZPB3g-0006jA-At for pgsql-admin@arkaria.postgresql.org; Tue, 11 Aug 2015 15:01:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZPB23-0004Gf-G7 for pgsql-admin@postgresql.org; Tue, 11 Aug 2015 15:00:03 +0000 Received: from gateway.pangburngroup.com ([12.230.133.165] helo=mail.liquidcore.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZPB1y-0004Sl-L9 for pgsql-admin@postgresql.org; Tue, 11 Aug 2015 15:00:01 +0000 Received: (from root@localhost) by mail.liquidcore.com (8.14.4/8.14.4) id t7BExsIX008277 for pgsql-admin@postgresql.org; Tue, 11 Aug 2015 09:59:54 -0500 Received: from [192.168.0.234] (ppasalalinux.nqadmin.com [192.168.0.234]) by mail.nqadmin.com with SMTP id 6625wy9fjk6si2zex2ywxpfsva; for pgsql-admin@postgresql.org; Tue, 11 Aug 2015 09:59:54 -0500 (CDT) (envelope-from dbadmin@nqadmin.com) Message-ID: <55CA0DEA.80203@nqadmin.com> Date: Tue, 11 Aug 2015 09:59:54 -0500 From: Prasanth Reddy Reply-To: dbadmin@nqadmin.com User-Agent: Mozilla/5.0 (X11; Linux i686; rv:31.0) Gecko/20100101 Thunderbird/31.8.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, I have posted a question about this same issue on JDBC thinking it is a driver issue. I was told this error is generated by the back-end itself rather than by the driver so posting the question in admin forum. See discussion on this here http://www.postgresql.org/list/pgsql-jdbc/since/201508080000/ I am currently running 9.1.9 and trying to upgrade to 9.4. I have done a dump and restore, when I start my java application I am getting the below error. 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). ERROR: invalid byte sequence for encoding "UTF8": 0x92 STATEMENT: SELECT * FROM client_data WHERE status_code = 0 ORDER BY client_name, description org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x92 > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) > at com.sun.rowset.JdbcRowSetImpl.execute(JdbcRowSetImpl.java:567) Same error with postgresql-9.4-1201.jdbc4.jar & postgresql-9.1-902.jdbc4.jar. Appreciate your help. Thanks, Prasanth -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin