Hi
If you are using BLOBs with Oracle, check out Google for Oracle java classes. There are a number of custom built classes to convert between Blobs & Strings. ([url=“http://download-east.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/index.html”]http://download-east.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/index.html[/url])
As for the other question, why are you combining String & BLOB data in a BLOB?? Can you influence the way the data is stored?
Chris