|Subject||Re: [Firebird-Java] inserting blobs through SQL Strings|
> I know I'm dancing with the devil and not listening to angels singingWorks only for text blobs. Max. size of statement - 64k
> "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 saidThe 0x notation is not supported.
> "token size exceeds limit".
> In the end I started inserting my blob data between String escape chars:But it is stored as text.
> way. That way it worked.
> Is there any way to insert the data as binary through a simple sql update?Nope.
PS: All this limitations of Firebird.