> I will try your example, maybe there is some issue in our driver which
> should be fixed.

I check your example, it is the CachedRowSet implementation that tries
to enforce the JDBC data type conversion table. Most likely they have no
other choice...

Please create a feature request in tracker, I think I can add a property
to tell driver to consider CHARACTER SET OCTETS as BINARY, VARBINARY or
LONGVARBINARY. The workaround that you use with a BLOB is bad - it
causes additional resource consumption on server and on the network level.

Roman