Re: ArrayIndexOutOfBoundsException in Encoding.decodeUTF8() - Mailing list pgsql-jdbc

From Joseph Shraibman
Subject Re: ArrayIndexOutOfBoundsException in Encoding.decodeUTF8()
Date
Msg-id 3E1C8E97.8090601@selectacast.net
Whole thread Raw
In response to Re: ArrayIndexOutOfBoundsException in Encoding.decodeUTF8()  (Barry Lind <blind@xythos.com>)
Responses Re: ArrayIndexOutOfBoundsException in Encoding.decodeUTF8()  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
Barry Lind wrote:
> Joseph,
>
> The problem is that your database claims to be ASCII, but you are
> storing non-ascii data in it.
>
> As of 7.3 the jdbc driver has the server convert from the database
> character set to UTF8.  Then send the data to the driver in UTF8 and the
> driver then decodes the UTF8 to java unicode.

I see this in my postgres log when I connect via jdbc:

LOG:  query: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) =
'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end;
LOG:  query: set client_encoding = 'UNICODE'; show autocommit

So if client_encoding is unicode why is the driver trying to convert from UTF8?


pgsql-jdbc by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: synchronized code
Next
From: Felipe Schnack
Date:
Subject: Re: synchronized code