From: Prasanth Reddy <dbadmin@nqadmin.com>
To: pgsql-admin@postgresql.org
Subject: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: Tue, 11 Aug 2015 09:59:54 -0500
Message-ID: <55CA0DEA.80203@nqadmin.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dbadmin@nqadmin.com
Subject: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
In-Reply-To: <55CA0DEA.80203@nqadmin.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox