Re: [HACKERS] JDBC connections to 9.1 - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: [HACKERS] JDBC connections to 9.1
Date
Msg-id 22092.1303138627@sss.pgh.pa.us
Whole thread Raw
Responses Re: [HACKERS] JDBC connections to 9.1  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] JDBC connections to 9.1  (Dave Cramer <pg@fastcrypt.com>)
Re: [HACKERS] JDBC connections to 9.1  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: [HACKERS] JDBC connections to 9.1  (Mike Fowler <mike@mlfowler.com>)
List pgsql-jdbc
Bernd Helmle <mailings@oopsware.de> writes:
> If i am reading it correct, it reads "UTF8" from the backend, while
> expecting "UNICODE" only. Not sure what change has caused this,
> though.

I am --- when I redid the GUC assign_hook logic a few weeks ago,
I changed the client_encoding code so that it shows the normalized
(official) name of the encoding, not whatever random string the client
sent over.  For instance, previous versions:

regression=# set client_encoding = 'UnIcOdE';
SET
regression=# show client_encoding ;
 client_encoding
-----------------
 UnIcOdE
(1 row)

versus HEAD:

regression=# set client_encoding = 'UnIcOdE';
SET
regression=# show client_encoding ;
 client_encoding
-----------------
 UTF8
(1 row)

I wasn't aware that JDBC would fail on that.  It's pretty annoying that
it does, but maybe we should grin and bear it, ie revert the change to
canonicalize the GUC's value?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: "Kasprzyk Maciej-FHC368"
Date:
Subject: feature request: make support for java.sql.Types.DISTINCT optional
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] JDBC connections to 9.1