> Sorry if this is mentioned somewhere, but it seems you cannot treat
> a BLOB SUB_TYPE 1 as an actual Blob?

Not really - we have sometime ago defined

BLOB SUB_TYPE 0 - Types.LONGVARBINARY
BLOB SUB_TYPE 1 - Types.LONGVARCHAR
BLOB SUB_TYPE <0 - Types.BLOB

Also if you want to have more generic solution, try to stick to
setBytes(byte[]), setBinaryStream(InputStream) and
setCharacterStream(Reader).

> Is this true?
>
> ps.setBlob( pos, newBlob );

At present no, but I think we can add this mapping - we are not consistent
here: getBlob() works, but setBlob(Blob) doesn't. Please fill this as a bug
or a feature request for JayBird.

Roman