Postgres Pro
Downloads
Home   >   mailing lists

Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 - Mailing list pgsql-jdbc

From Prasanth Reddy
Subject Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date
Msg-id 55C4DF1F.2060808@nqadmin.com
Whole thread Raw
Responses Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92  (Prasanth Reddy <dbadmin@nqadmin.com>)
List pgsql-jdbc
Tree view 
Hi,

I have recently migrated to 9.4.4 from 9.1. I did a dump and restore to migrate the database. When I try to connect
usingJDBC I am getting the following error, the database encoding is SQL_ASCII. 
Same error with postgresql-9.4-1201.jdbc4.jar & postgresql-9.1-902.jdbc4.jar.

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)

Command used to create the database
/usr/local/pgsql/bin/createdb --encoding=SQL_ASCII --template=template0 db_server

Thanks,
Prasanth

pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Re: Release schedule
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92