Kristian Waagan wrote:
> 
> I think you have to add "CAST (X'many-hex-values' AS BLOB)" in your 
> statement

Yes, that does work, even for my larger object. I think that, according to
SQL:2003, the original value specification should have been recognized as a
binary string literal (i.e. a value of type BLOB). In fact, I find no
mention of type CHAR FOR BIT DATA in the standard. Nevertheless, the cast
specification is standard SQL.
-- 
View this message in context: 
http://www.nabble.com/VALUES-expression%2C-BLOB%2C-and-using-ij-tf3808458.html#a10861850
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Reply via email to