| From: | Prasanth Reddy <dbadmin(at)nqadmin(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 |
| Date: | 2015-08-07 16:38:55 |
| Message-ID: | 55C4DF1F.2060808@nqadmin.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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 using JDBC 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Sitnikov | 2015-08-07 20:09:55 | Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 |
| Previous Message | dmp | 2015-08-07 16:31:32 | Re: Release schedule |