Subject inserting blobs through SQL Strings
Author nagypapi
I know I'm dancing with the devil and not listening to angels singing
"Use PreparedStatements", but I was wondering about inserting blobs
through statement.executeUpdate("insert into blobtable(id,blobfield)
values(1,<my blob insertion text here>);

I tried a hex string, no luck. I tried 0xhex_string, no luck, it said
"token size exceeds limit".

In the end I started inserting my blob data between String escape chars:
'hex_string'
way. That way it worked.

Is there any way to insert the data as binary through a simple sql update?

Thanks,
John