Skip site navigation (1) Skip section navigation (2)

8.0.0beta4: "copy" and "client_encoding"

From: mbch67(at)yahoo(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: 8.0.0beta4: "copy" and "client_encoding"
Date: 2004-11-03 16:03:01
Message-ID: fe065ce.0411030803.4616e8c4@posting.google.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-11-03 19:38:21
Subject: Re: stable release
Previous:From: Dave CramerDate: 2004-11-03 12:38:29
Subject: Re: stable release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group