Re: Bytea Hex Format - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Bytea Hex Format
Date
Msg-id alpine.BSO.2.00.0908101851360.16919@leary.csoft.net
Whole thread Raw
In response to Bytea Hex Format  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc

On Mon, 10 Aug 2009, dmp wrote:

> "Support hex-string input and output for type BYTEA.  Both hex format
> and the traditional "escape" format are automatically handled on
> input.  The output format is selected by the new GUC variable
> bytea_output.  As committed, bytea_output defaults to HEX, which is
> an *incompatible change*.
>
> Is this going to effect the JDBC default behavior, currently the
> the MySQLView program uses getBytes() to dump data for BYTEA and
> that is in Octal format.
>

It will require a change to the JDBC driver to correctly interpret hex
escaped bytea data (which hasn't happened yet), but JDBC users will not
need to change anything, getBytes will still be the call to use.

Kris Jurka


pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Bytea Hex Format
Next
From: Kris Jurka
Date:
Subject: Re: Using BigInteger as argument to AbstractJdbc2Statement.setObject