Re: JDBC driver reports a protocol error for a CVS HEAD server - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC driver reports a protocol error for a CVS HEAD server
Date
Msg-id Pine.BSO.4.64.0704241917230.6942@leary.csoft.net
Whole thread Raw
In response to JDBC driver reports a protocol error for a CVS HEAD server  ("Ned T. Crigler" <crigler@users.sourceforge.net>)
Responses Re: [HACKERS] JDBC driver reports a protocol error for a CVS HEAD server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc

On Tue, 24 Apr 2007, Ned T. Crigler wrote:

> The JDBC driver does not connect successfully to a CVS HEAD server
> (updated as of today) when using a database set to UTF8 encoding;
> enabling the debug messages in the driver shows that it is sending
> client_encoding=UNICODE in the startup packet, but the server is
> reporting client_encoding=UTF8 back to the driver, causing the driver
> to complain:

Indeed, referring to -hackers as this is a recent backend change.  The
backend is reporting the database encoding as the client encoding.  When a
connection is created with a startup packet sending client_encoding =
UNICODE the server responds with a ParameterStatus message of
client_encoding = server encoding.  So something has gone wrong here.
It's not just a UNICODE/UTF-8 problem as I see the server responding with
LATIN1 with a LATIN1 database.

Kris Jurka


pgsql-jdbc by date:

Previous
From: "Ned T. Crigler"
Date:
Subject: JDBC driver reports a protocol error for a CVS HEAD server
Next
From: tsuchikawa.takuya@oss.ntt.co.jp (土川 卓哉)
Date:
Subject: Question for the XAConnections default autocommit state