Subject Re: [Firebird-Java] inserting blobs through SQL Strings
Author Roman Rokytskyy
> 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>);

Works only for text blobs. Max. size of statement - 64k

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

The 0x notation is not supported.

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

But it is stored as text.

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



PS: All this limitations of Firebird.