I had read that post prior and it would require me converting the text that I am attempting to insert, an xslt file, into a hex representation. Only then could I attempt to do this. I did actually attempt this. (not very friendly) I did convert the contents of my file into a hex representation and attempted the insert by performing a CAST( X'text content' AS BLOB), but it complained when I executed the SQL. While this would be a viable approach, I think you would agree that this is far from desirable.
What would be optimal would be the ability to have Derby allow inserts of TEXT into BLOB fields. I know that this is how Sybase ASE operates, (Yes, I know Derby is not ASE) and I don't know if this is ANSI standard, but it sure makes life less complicated. -- View this message in context: http://www.nabble.com/Inserting-into-BLOB-field-tp23841004p23855280.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
