8.0.0beta4: "copy" and "client_encoding" - Mailing list pgsql-jdbc

Hi,

The following statement worked fine with 7.4 but fails under 8.0.0beta4:

   SET CLIENT_ENCODING TO 'LATIN1';

Error message:

   08006
   The servers client_encoding parameter was changed to {0}.
   The JDBC driver requires client_encoding to be UNICODE for
   correct operation.

Is this a bug or a new restriction of the JDBC driver/server backend?

That's the (faulty) 8.0.0beta4 configuration:

   Default client encoding: LATIN1
   Database encoding:       UNICODE
   DBMS:                    8.0.0beta4
   JDBC driver:             pgdev.307.jdbc3.jar
   File encoding:           LATIN1

That's the 7.4.x configuration:

   Default client encoding: LATIN1
   Database encoding:       UNICODE
   DBMS:                    7.4.x
   JDBC driver:             pg74.213.jdbc4.jar
   File encoding:           LATIN1


Adrian