Subject | inserting blobs through SQL Strings |
---|---|
Author | nagypapi |
Post date | 2008-09-10T09:13:12Z |
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
"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