Re: Bytea Hex Format

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