5 messages in com.mysql.lists.javaRe: Binary output on SHOW FULL PROCES...
FromSent OnAttachments
Alan R Williamson15 Feb 2006 10:07 
Mark Matthews15 Feb 2006 11:24 
Alan R Williamson15 Feb 2006 12:54 
Paul Palaszewski15 Feb 2006 16:19 
Alan R Williamson20 Feb 2006 03:44 
Subject:Re: Binary output on SHOW FULL PROCESSLIST
From:Alan R Williamson (al@spikesource.com)
Date:02/15/2006 12:54:48 PM
List:com.mysql.lists.java

Thanks Mark for that.

So can I conclude, that the metadata for that field has changed in MySQLv5. The same code works if i point it to a MySQL4 datasource, but fails to display text, when pointed towards MySQL5.

Is that a correct assumption?

Mark Matthews wrote:

-----BEGIN PGP SIGNED MESSAGE----- If I look at the metadata returned for this field, I see that the server says that it is:

FIELD_TYPE_VAR_STRING, with a character set of "binary", with the isBinary column flag set. Unfortunately, this is the _exact_ same "fingerprint" the server uses for the BINARY/VARBINARY type, which by the JDBC spec maps to byte[]. Thus if you use ResultSet.getObject(), you will get the byte[] that represents the data. If you pass this to something that .toStringifies it, you'll get the array "address", like [B@nnnnnn on most JVMs.